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 normalization