Re: ORA-00960 "Ambiguous column..."
From: Snufupagus <snufupagus_at_aol.com>
Date: 1996/01/23
Message-ID: <4e3ha5$pu9_at_newsbf02.news.aol.com>#1/1
Date: 1996/01/23
Message-ID: <4e3ha5$pu9_at_newsbf02.news.aol.com>#1/1
This probably means you have a column in two of the tables in your query which have the same name. Oracle doesn't know which to retrieve. You can solve this one of two ways.
select table1.column from table1, table2 where ... or
select a.column from table1 a, table2 b where ...
Ken Received on Tue Jan 23 1996 - 00:00:00 CET