Contents of the PROMOTION table
Structure of the BOOKS table
-How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?
A) 4
B) 3
C) 2
D) 1

Question

​
Contents of the PROMOTION table
  Structure of the BOOKS table
-How many joining conditions will be required in an SQL statement that is used to determine the gift that corresponds to each book in the BOOKS table?​
A) ​4 
B) ​3 
C) ​2 
D) ​1

Quizplus · Accepted Answer

To determine the gift that corresponds to each book in the BOOKS table, you only need one joining condition that matches the relevant columns in the BOOKS table with those in the GIFTS table (assuming there is a GIFTS table or a similar table that contains gift information).

​ Contents of the PROMOTION Table

Contents of the PROMOTION Table