Question
3.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
Answer
B. SELECT title, name
FROM books JOIN publisher
USING (pubid);