× Didn't find what you were looking for? Ask a question
Top Posters
Since Sunday
k
4
c
4
M
3
t
3
i
3
B
3
k
3
m
3
c
3
o
3
l
3
r
3
Home Q & A Board Other Fields Homework Help Business Management
New Topic  
BoyzGonWild BoyzGonWild
wrote...
Go to Answer
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 47 times
1 Reply
Replies
Answer verified by a subject expert
leannaolsenleannaolsen
wrote...
#1
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
Thanks
julymontalvo
wrote...

Yesterday
Thank you, thank you, thank you!
julymontalvo
wrote...

2 hours ago
This helped my grade so much Perfect
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  875 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 577
  
 404
  
 279
Your Opinion
How often do you eat-out per week?
Votes: 80
Previous poll results: Which of the following is the best resource to supplement your studies: