Structure of the BOOKS table
Structure of the PUBLISHER table
-Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table,as well as the name of the contact person and the phone number to call to reorder the book?
A) SELECT title,cost,contact,phone FROM publisher,books;
B) SELECT title,cost,contact,phone FROM publisher JOIN books USING (pubid);
C) SELECT title,cost,contact,phone FROM publisher JOIN books USING (isbn);
D) SELECT title,cost,contact,phone FROM publisher JOIN books USING (contact);

Question

Structure of the BOOKS table
  Structure of the PUBLISHER table
-​Which of the following SQL statements will display the title and cost of each book stored in the BOOKS table,as well as the name of the contact person and the phone number to call to reorder the book?
A) SELECT title,cost,contact,phone FROM publisher,books; 
B) SELECT title,cost,contact,phone FROM publisher JOIN books USING (pubid); 
C) SELECT title,cost,contact,phone FROM publisher JOIN books USING (isbn); 
D) SELECT title,cost,contact,phone FROM publisher JOIN books USING (contact);

Quizplus · Accepted Answer

The correct statement should use the JOIN keyword to join the tables on a common column, which is the pubid in this case, to obtain the corresponding contact person and phone number from the PUBLISHER table. USING should be used instead of ON since the column name is the same in both tables.

Structure of the BOOKS Table