​ Structure of the ORDERS Table

question 70

Multiple Choice

​
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