Computer Science
Which product is returned in a join query have no join condition ?
- Equijoins
- Cartesian product
- Both (1) and (2)
- None of the mentioned
SQL Joins & Grouping
2 Likes
Answer
Cartesian product
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
The following SQL is which type of join :
SELECT CUSTOMER.CUST_ID, ORDER.CUST_ID, NAME, ORDER_ID FROM CUSTOMER, ORDER WHERE CUSTOMER.CUST_ID = ORDER.CUST_ID?- Equi-join
- Natural join
- Outer join
- Cartesian product
The following SQL is which type of join :
SELECT CUSTOMER.CUST_ID, ORDER.CUST_ID, NAME, ORDER_ID FROM CUSTOMER, ORDER- Equi-join
- Natural join
- Outer join
- Cartesian product
Which is a join condition contains an equality operator ?
- Equijoins
- Cartesian product
- Both (1) and (2)
- None of the mentioned
Fill in the blanks:
To specify condition with a GROUP BY clause, _________ clause is used.