Question

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

Answer 1

Self Join

Step-by-step explanation:

Required

The type of JOIN

Notice that the given query joins the customer table and the order table without using the keyword join.

SQL queries that join tables without using the keyword is referred to as self join.

Other types of join will indicate the "join type" in the query