Question: Which of the following queries contains an equality join? a. SELECT title, authorid FROM books, bookauthor WHERE books.isbn = bookauthor.isbn AND retail > 20; b.

Which of the following queries contains an equality join?

a. SELECT title, authorid

FROM books, bookauthor

WHERE books.isbn = bookauthor.isbn

AND retail > 20;

b. SELECT title, name

FROM books CROSS JOIN publisher;

c. SELECT title, gift

FROM books, promotion

WHERE retail >= minretail

AND retail <= maxretail;

d. None of the above

Step by Step Solution

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

c SELECT title ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (2 attachments)

PDF file Icon

1803_60b8c12127930_716465.pdf

180 KBs PDF File

Word file Icon

1803_60b8c12127930_716465.docx

120 KBs Word File

Students Have Also Explored These Related Oracle 12c SQL Questions!