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?
Select * From department, employee;All records from department and all records from employee tables will be returned.