Multiple choice technology databases

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

  1. Equi-join

  2. Natural join

  3. Outer join

  4. Cartesian join
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The query uses the equality operator (=) in the WHERE clause to match keys from both tables, which defines an equi-join. It is not a natural join because it explicitly names the joining columns rather than matching implicitly.

Keep practicing — related questions