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
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)
1803_60b8c12127930_716465.pdf
180 KBs PDF File
1803_60b8c12127930_716465.docx
120 KBs Word File
