Computer Science
A join query without the join condition produces a cartesian product.
SQL Joins & Grouping
3 Likes
Answer
True
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
2 Likes
Related Questions
HAVING clause can only be used if the SELECT query has GROUP BY clause.
With GROUP BY, the select-list of the SELECT statement can only take the group-field and/or aggregate function.
You can specify any type of condition, using any comparison operator in an equi-join.
Join can only be created from two tables.