A

Admin • 828.03K Points
Coach

Q. The following SQL is which type of join:

Code:
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) Cartesian join
  • (B) Outer join
  • (C) Natural join
  • (D) Equi-join
  • Correct Answer - Option(D)
  • Views: 13
  • Filed under category SQL Server
  • Hashtags:

No solution found for this question.
Add Solution and get +2 points.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.