Advanced SQL - Technical MCQs

Q1:

The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID

A Equi-join

B Natural join

C Outer join

D Cartesian join

ANS:A - Equi-join

No answer description is available