Problem solve
Get help with specific problems with your technologies, process and projects.
Joining tables without common columns
How do I join two tables without common columns and display any two columns, all records in a corresponding table?
How do I join two tables without common columns and display any two columns, all records in a corresponding table?
When you join two or more tables without a common column, it is called a Cartesian product. When this happens, rows from all rows from each table will be returned. For example:
Select * From department, employee;All records from department and all records from employee tables will be returned.
