​ Structure of the ORDERS Table

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