I have been using SQL for 25 years and I just learned today that SELECT [...] FROM Table1, Table2
is called a “cross join” an can also be expressed as SELECT [...] FROM Table1 CROSS JOIN Table2
. 🤦 In my defense, I must say that I have only had to use a cross join a few times in my entire career.
Read other posts