Computer Science
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
SQL Joins & Grouping
1 Like
Answer
Equi-join
Reason — An equi-join is a type of join where columns from two or more tables are compared for equality using the "=" operator. In the given SQL query, the WHERE clause specifies the condition CUSTOMER.CUST_ID = ORDER.CUST_ID, which compares the CUSTID column from the CUSTOMER table with the CUSTID column from the ORDER table. Therefore, it is an equi-join.
Answered By
2 Likes
Related Questions
Which clause cannot be used with "aggregate functions" ?
- GROUP BY
- SELECT
- WHERE
- Both (1) and (3)
What is the meaning of "WHERE" clause in a GROUP BY query ?
- To filter out the summary groups
- To filter out the column groups
- To filter out the row and column values before creating groups
- None of the mentioned
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 product is returned in a join query have no join condition ?
- Equijoins
- Cartesian product
- Both (1) and (2)
- None of the mentioned