Please give me two ways by SQL syntax:

a) traditional join with the WHERE clause b) join with the JOIN keyword

Thank you.

List the ISBN, title, author last name(s), retail price, and the promotional gift for all books. For books with multiple authors list both author's names but it is also OK if only one was provided

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