Answer:
Answers explained below
Explanation:
<u>The two related table are:
</u>
i) Books Table
ii) BOOKAUTHOR Table
<u>The common field between the two tables are:
</u>
i) ISBN attribute
<u>The columns that i would like to display are:
</u>
Title, ISBN, AuthorID, PubID, PubDate, Cost, Retail, Discount, Category
<u>Sql Code to join tables using where clause
</u>
select t1.Title, t1.ISBN, t2.AuthorID, t1.PubID, t1.PubDate, t1.Cost, t1.Retail, t1.Discount, t1.Category from Books t1 INNER JOIN BOOKAUTHOR t2 ON t1.ISBN = t2.ISBN where t1.ISBN = 0401140733
The above query will dispaly the attributes of table "Books" and of table "BOOKAUTHOR" for book ISBN 0401140733
<u>Repeat problem 1 but remove the WHERE statement
</u>
After removing the where condition we will have following join query
select t1.Title, t1.ISBN, t2.AuthorID, t1.PubID, t1.PubDate, t1.Cost, t1.Retail, t1.Discount, t1.Category from Books t1 INNER JOIN BOOKAUTHOR t2 ON t1.ISBN = t2.ISBN
The above query will display all the mapping data of table "Books" and of Table "BOOKAUTHOR"
