CROSS JOIN for all combinations

It is the cartesian products of both tables, if you're a math nerd.

📌 Syntax:
𝚂𝙴𝙻𝙴𝙲𝚃 *
𝙵𝚁𝙾𝙼 𝚝𝚊𝚋𝚕𝚎_𝟷
𝙲𝚁𝙾𝚂𝚂 𝙹𝙾𝙸𝙽 𝚝𝚊𝚋𝚕𝚎_𝟸

Note that there is no need for an ON clause.

CROSS JOIN is useful for getting all combinations
- Matching users with all dates.
- Match product tables with color tables to get product of all colors

🛑 Be careful though! CROSS JOIN can be very expensive, especially when the tables are huge.

Example:
If the user table has 100 records, and date table has 365 records, the result of 𝘾𝙍𝙊𝙎𝙎 𝙅𝙊𝙄𝙉 is a table of of all users for all the dates (100x365 = 36500 records)

👇 If you're confused, the example below might clarify better. Check it out!