Structure of the ORDERS table
Structure of the CUSTOMERS table

-Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table,and,if the customer has placed an order that is contained in the ORDERS table,the order# of any order each customer has placed?
A) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NOT NULL;
B) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# (+)= customers.customer#;
C) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# = customers.customer# (+);
D) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NULL;

Question

​
Structure of the ORDERS table
  Structure of the CUSTOMERS table
​
-​Which of the following SQL statements will list the name of each customer stored in the CUSTOMERS table,and,if the customer has placed an order that is contained in the ORDERS table,the order# of any order each customer has placed?
A) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NOT NULL; 
B) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# (+)= customers.customer#; 
C) SELECT lastname,firstname,order# FROM customers,orders WHERE orders.customer# = customers.customer# (+); 
D) SELECT lastname,firstname,order# FROM customers NATURAL JOIN orders WHERE orders.customer# IS NULL;

Quizplus · Accepted Answer

Option B uses a left outer join to join the two tables based on the customer# column. This ensures that all customers are included in the result, and any matching orders are also included. The order# column is selected along with the names of customers. The other options either include only customers with orders or exclude customers with orders altogether.

​ Structure of the ORDERS Table

Structure of the ORDERS Table