Informatics Practices

Which product is returned in a join query having no join condition ?

  1. Equi-join
  2. Cartesian
  3. Both Equijoins and Cartesian
  4. Natural

SQL Joins & Grouping

2 Likes

Answer

Cartesian

Reason — When a join query has no join condition specified, it results in a Cartesian product. This means that every row from the first table is combined with every row from the second table.

Answered By

3 Likes


Related Questions