Structure of the ORDERS table
Structure of the CUSTOMERS table

-Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?
A) SELECT * FROM orders,customers;
B) SELECT lastname,firstname,order# FROM orders NATURAL JOIN customers;
C) SELECT lastname,firstname,order# FROM orders,customers WHERE orders.customer# = customers.customer#;
D) all of the above

Question

​
Structure of the ORDERS table
  Structure of the CUSTOMERS table
​
-​Which of the following queries will display data from both the ORDERS and CUSTOMERS tables?
A) ​SELECT * FROM orders,customers; 
B) SELECT lastname,firstname,order# FROM orders NATURAL JOIN customers; 
C) SELECT lastname,firstname,order# FROM orders,customers WHERE orders.customer# = customers.customer#; 
D) ​all of the above

Quizplus · Accepted Answer

All the options provided are examples of queries that will display data from both the ORDERS and CUSTOMERS tables, albeit using different methods (cross join, natural join, and inner join with a WHERE clause).

​ Structure of the ORDERS Table

Structure of the ORDERS Table