Which of the following SQL statements is not valid? a. SELECT b.isbn, p.name FROM books b NATURAL

Question:

Which of the following SQL statements is not valid?

a. SELECT b.isbn, p.name

FROM books b NATURAL JOIN publisher p;

b. SELECT isbn, name

FROM books b, publisher p

WHERE b.pubid = p.pubid;

c. SELECT isbn, name

FROM books b JOIN publisher p

ON b.pubid = p.pubid;

d. SELECT isbn, name

FROM books JOIN publisher

USING (pubid);

e. None—all the above are valid SQL statements.

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: