Re: why can't I create this VIEW?

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/01/18
Message-ID: <19970118195600.OAA17526@ladder01.news.aol.com>#1/1

From original note >>

SQL> CREATE VIEW climate.stations as

   select nws_stations.ucan_station_id,station_name,nws_station_id from    ucan_stations a,nws_stations b
   where a.ucan_station_id = b.ucan_station_id;

select nws_stations.ucan_station_id,station_name,nws_station_id from

                    *

ERROR at line 2:
ORA-00904: invalid column name
<<

Try prefixing the column name with the table_name label, not the table_name, i.e., a.ucan_station_id. Received on Sat Jan 18 1997 - 00:00:00 CST