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?

    Requires Free Membership to View

    Login

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.

This was first published in October 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top