× 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  
chem1111 chem1111
wrote...
Go to Answer
Posts: 673
Rep: 0 0
6 years ago
Which of the following will display the title, publication date, and publisher name of each book in the BUSINESS category?
 a. SELECT title, pubdate, nameFROM publisher JOIN books USING (pubid)WHERE category = 'BUSINESS';
  b. SELECT title, pubdate, nameFROM publisher JOIN books ON (pubid)WHERE category = 'BUSINESS';
  c. SELECT title, pubdate, nameFROM publisher OUTER JOIN books USING (pubid)WHERE category = 'BUSINESS';
  d. SELECT title, pubdate, nameFROM publisher CROSS JOIN books USING (pubid)WHERE category = 'BUSINESS';
Read 54 times
2 Replies
Replies
Answer verified by a subject expert
jgfndjgfnd
wrote...
#1
Top Poster
Posts: 871
Rep: 1 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
1

Related Topics

chem1111 Author
wrote...
#2
6 years ago
Now I'm convinced to ask more questions Slight Smile
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  874 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 2218
  
 862
  
 930
Your Opinion
Previous poll results: Where do you get your textbooks?