Answered step by step
Verified Expert Solution
Question
1 Approved Answer
SQL Just using traditional join with the WHERE clause (not ANSI join with the JOIN keyword) List all book titles and the first and last
SQL
Just using traditional join with the WHERE clause (not ANSI join with the JOIN keyword)
List all book titles and the first and last names of the customer(s) who ordered each title. Be sure to show the titles of the books that were not ordered.
I want to it will show up like this:
Thank you.
Here is the structure:
COOKING WITH MUSHROOMS KENNETH JONES E-BUSINESS THE EASY WAY JAKE LUCAS BODYBUILD IN 10 MINUTES A DAY JAKE LUCAS COOKING WITH MUSHROOMS JAKE LUCAS CROSS KILL BUILDING A CAR WITH TOOTHPICKS CROSS JUSTICE RAISING INDEPENDENT KIDS THE FAMILY BUDGET CUSTOMERS Customer Lastname Firstname Email Address City State Zip Referred Region ORDERS Order# Customer Orderdate Shipdate Shipstreet Shipcity Shipstate Shipzip Shipcost ORDERITEMS Order# Item# ISBN Quantity Paideach BOOKAUTHOR AUTHOR BOOKS ISBN Authord ISBN AuthorID Lname Title Fname Pubdate PubID Cost Retail Discount PUBLISHER Category PublD Name PROMOTION Contact Phone Gift Minretall Maxretail FIGURE 1-5 JustLee Books's table structures after normalizationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started