List the customers (name) and their orders details.

Q. List the customers (name) and their orders' details.

Consider  this table --

You can understand by seeing this video ---

Answer =

SELECT NAME , DESCRIPTION , PRICE FROM ORDERS , PARTS  WHERE ORDERS.PARTNUM = PARTS.PARTNUM ;