Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> same record multiple tables
I am trying to select simlar information from multiple tables in the
following sql statement but get the following error. I understand why i
get the error. Is there an easy way arround it.
SELECT DATE_RECEIVED"Date Received" ,cph"CPH" ,opt_object_id, mag_object_id From DOC_CORRESPONDENCE, DOC_APPLICATION, DOC_MOVEMENT WHERE CPH like '12%'
SQL Exception: ORA-00918: column ambiguously defined
-- Posted via Mailgate.ORG Server - http://www.Mailgate.ORGReceived on Wed Nov 05 2003 - 03:09:33 CST
![]() |
![]() |