Q
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.

Dig Deeper on Oracle and SQL

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close