Cross Join is used to combine each row of one table with each row of another table, and return the Cartesian product of the sets of rows from the tables that are joined.
INNER
LEFT OUTER
RIGHT OUTER
SELF
CROSS JOIN
Other joins have ON keyword in Syntax but Cross Join not required ON at the time of writing the query...
On this page of the site you can watch the video online SQL SERVER||Cross Join use case with a duration of hours minute second in good quality, which was uploaded by the user SQLtoSSIStoPowerBI 12 November 2022, share the link with friends and acquaintances, this video has already been watched 242 times on youtube and it was liked by 1 viewers. Enjoy your viewing!