SQL JOIN command

Can we use SQL JOIN command , If we don't have any common column available between them

27th Jun 2022, 7:15 AM
Ranjeet Kaur
Ranjeet Kaur - avatar
1 ответ
+ 11
If there is no a common column, what is the point of joining tables? If you want to get rows from both tables in a single result, you can use UNION ALL.
27th Jun 2022, 7:25 AM
Igor Makarsky
Igor Makarsky - avatar