Oracle gurus (Specifically CREATE VIEW gods)

[Hawkeye-X]

What am I doing wrong?


CREATE VIEW PAPERBACK AS
SELECT BOOK_CODE, TITLE, PUBLISHER_NAME, PRICE FROM
BOOK, PUBLISHER WHERE
PAPERBACK = ‘Y’ AND
PUBLISHER.PUBLISHER_CODE = PUBLISHER.PUBLISHER_CODE;

It tells me that I'm missing an expression on line 3

I'm supposed to call everything with ALL paperback and
the publisher name is on a different table (PUBLISHER) instead
of the book table. The book table has a foreign key (PUBLISHER_CODE)
to help reference the PUBLISHER table.

Hawkeye-X

[jono]

1. Aliases

Both your tables are aliased PUBLISHER in your join statement:

PUBLISHER.PUBLISHER_CODE = PUBLISHER.PUBLISHER_CODE

I assume it should read:

BOOK.PUBLISHER_CODE = PUBLISHER.PUBLISHER_CODE

:hi:

[WhoCountsTheVotes]

2. line 3

PUBLISHER.PUBLISHER_CODE = PUBLISHER.PUBLISHER_CODE

should be

PUBLISHER.PUBLISHER_CODE = BOOK.PUBLISHER_CODE

probably
:)