Which of the following queries contains an equality join?

Question

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

Answer 1

Answer:

A. SELECT title, authorid
FROM books, bookauthor
WHERE books.isbn = bookauthor.isbn
AND retail>20;