Using the Tal Distrbutors Database from A Guide To SQL (9th Edition), create a l

Question

Using the Tal Distrbutors Database from A Guide To SQL (9th Edition),  create a list of all customers, including name and customer number, as well as the order number and date of any orders they may have placed. The list of customers must include all customers, even if the customer had not placed any orders.

Schema:

?eject Browser ? ? c ?127.0.0.1:8080/apex/f?p-4500:1001:645686924296311-NO::: ORACLE Application Express welcome SYSTEM I Logout ? Home Application Bulder SQL Workshop - Hame S0L Workshop Object Browser Scherma LAL ' Help Tatles Create ? APEXS ACL APEXS_WS FILES WS HSTORY APEXS WS LINKS APEXS WS NOTES APLXS_Ws ROWS APEXS WS TAGS APEKS WS WEBPG SECTIONS DEMO CUSTOMERS DEMO ORDERS DEMO ORDER ITEMS DEMO PRODUCT DEMO STATES DEMO USERS DEPT HTMLDB PLAN REP Appication Lxpress 4.0 2.00.09 Wolapac TAL Uaer SYSTEM Language en Copynght &1330, 2010, Crade All rihts eserved

Explanation / Answer

The above is the sql query which can list the customer number along with his name and order details if they placed any orders otherwise it will list only customer information.

Here we have left join which can lists all the customer information because it is the left table and it will lists the matching records from the right table i.e.Orders table if there is no information or customer doesn't order anything those customer information will be listed and the corresponding order attributes will be null in the output.

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.