What is the name of a result that returns all the rows in all the tables listed in the query?
Explanation
Get an explanation when it's available:
Theory
  • The CARTESIAN JOIN or CROSS JOIN returns the Cartesian product of the sets of records from the two or more joined tables. Thus, it equates to an inner join where the join-condition always evaluates to True or where the join-condition is absent from the statement.

    Syntax:

    The basic syntax of CARTESIAN JOIN or CROSS JOIN is as follows:
    SELECT table1.column1, table2.column2...
    FROM  table1, table2 [, table3 ]
    

    Read more: SQL - CARTESIAN or CROSS JOINS

Follow CodeGalaxy

Mobile Beta

Get it on Google Play
Send Feedback
Keep exploring
SQL quizzes
Cosmo
Sign Up Now
or Subscribe for future quizzes