Re: ORA-00960 "Ambiguous column..."

In article <4e17kl$add_at_lal.interserv.net>, deangup_at_admin.ci.seattle.wa.us writes:
|> A user is getting ORA-00960 in MS ACCESS 2.0 running on WINDOWS 3.1 attaching to tables in
|> ORACLE 7.0.15 running on AIX. Text of message: "Ambiguous column naming in select list." I can't find
|> the message in ORACLE7 SERVER MESSAGES AND CODES MANUAL (3605-70-1292); going by
|> message numbers I expected it on page 2-54. (Maybe somebody with a later version of Oracle will have it
|> in their manual?) The columns in the user's ACCESS SQL statement appear to be fully qualified. Thanks
|> for any information about this error!
|>

Using the 'oerr' utility on Unix, here's what I found:

00960, 00000, "ambiguous column naming in select list"

// *Cause: A column name in the order-by list matches more than one select
//         list columns.
// *Action: Remove duplicate column naming in select list.