Views and columns in views...

Howdy,

I'm using Oracle-7 with Powerbuilder, and am running into problems with selecting from Views. From the PB Database administrator, I create a View; the View is actually a join across a couple of tables. Then, when I query the View and use a column from the View in a WHERE clause, I get an "Invalid column name" message. What am I doing wrong? Here's an example of the situation:

CREATE VIEW MyView (Column1, Column2, Column3) AS SELECT TableA.Column1, TableA.Column2, TableB.Column3 FROM TableA, TableB
WHERE TableA.JoinCol = TableB.JoinCol

Then, selecting from this view as follows:

SELECT *
FROM MyView

works successfully, but

SELECT *
FROM MyView
WHERE Column1="somevalue"

returns with an "Invalid Column Name" message.

Any idea what's wrong here, or is this a limitation of Oracle's implementation of Views?

Thanks for any responses,

Dave Received on Mon Mar 27 1995 - 22:26:41 CEST