What does the following query returns? SELECT C.CUST_ID, C.CUST_NAME, O.ORDER_NUMBER
FROM CUSTOMERS C LEFT JOIN ORDERS O
ON C.CUST_ID = O.CUST_ID
WHERE O.ORDER_NUMBER IS NUL L;

Question

What does the following query returns? SELECT  C.CUST_ID, C.CUST_NAME, O.ORDER_NUMBER  
 FROM  CUSTOMERS C  LEFT JOIN  ORDERS O  
 ON  C.CUST_ID = O.CUST_ID  
 WHERE  O.ORDER_NUMBER  IS NUL L;

Accepted Answer

Customers with no orders

Answer

Only customers who placed orders

Answer

Orders with missing customers

Answer

All customers including the ones with no orders

Crowdly

What does the following query returns? SELECT C.CUST_ID, C.CUST_NAME, O.ORDER_N...

Want instant access to all verified answers on eclass.yorku.ca?