Which SQL JOIN can be applied if there is no relationship between the two tables?

You can replace the JOIN keyword with a comma in the FROM clause. What do you do next? There’s no ON keyword for you to state the joining condition as there would be when using JOIN , e.g., on which two columns you want to join the tables.

I think full other join

CROSS join