× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
A
6
j
6
c
5
m
5
C
5
d
5
s
5
n
4
i
4
d
4
d
4
J
4
New Topic  
BoyzGonWild BoyzGonWild
wrote...
Posts: 719
Rep: 0 0
6 years ago
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, phoneFROM publisher, books;
  b. SELECT title, cost, contact, phoneFROM publisher JOIN booksUSING (pubid);
  c. SELECT title, cost, contact, phoneFROM publisher JOIN booksUSING (isbn);
  d. SELECT title, cost, contact, phoneFROM publisher JOIN booksUSING (contact);
Read 45 times
1 Reply
Replies
Answer verified by a subject expert
leannaolsenleannaolsen
wrote...
Top Poster
Posts: 875
Rep: 3 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

BoyzGonWild Author
wrote...

6 years ago
This calls for a celebration Person Raising Both Hands in Celebration
wrote...

Yesterday
You make an excellent tutor!
wrote...

2 hours ago
Helped a lot
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  510 People Browsing
 123 Signed Up Today
Related Images
  
 301
  
 934
  
 384
Your Opinion
What's your favorite math subject?
Votes: 315

Previous poll results: What's your favorite coffee beverage?