Loading

Sql Server Join

Jimmy Underwood

14y2.1k

Hi,

The following SQL is which type of join used in:

SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi14y ago
Hi,

Above query is used INNER JOIN.
It is ANSI Standrad..

SQL Standrad is

SELECT C. CUSTOMER_ID, O. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T C
INNER JOIN ORDER_T O ON C.CUSTOMER_ID = O.CUSTOMER_ID

hope this help.