Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> same record multiple tables

same record multiple tables

From: Clive Moore <helloclive_at_hotmail.com>
Date: Wed, 5 Nov 2003 09:09:33 +0000 (UTC)
Message-ID: <d8a2d7e7271fa6281fa152be47156752.35643@mygate.mailgate.org>


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.ORG
Received on Wed Nov 05 2003 - 03:09:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US