Which of the following queries contains a non-equality join? a. SELECT title, authorid FROM books, bookauthor WHERE

Question:

Which of the following queries contains a non-equality join?

a. SELECT title, authorid

FROM books, bookauthor

WHERE books.isbn = bookauthor.isbn

AND retail > 20;

b. SELECT title, name

FROM books JOIN publisher

USING (pubid);

c. SELECT title, gift

FROM books, promotion

WHERE retail >= minretail

AND retail <= maxretail;

d. None of the above

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Oracle 12c SQL

ISBN: 978-1305251038

3rd edition

Authors: Joan Casteel

Question Posted: