SQL - Should produce an error and doesn't, please help.
From: Doug Moloney <Doug.Moloney_at_ae.ge.com>
Date: 1996/12/06
Message-ID: <32A83E3F.4F82_at_ae.ge.com>#1/1
Date: 1996/12/06
Message-ID: <32A83E3F.4F82_at_ae.ge.com>#1/1
SELECT PartNo FROM table_1
The partno column in publicview is not a valid column name. Oracle
should give me an error, but instead runs the query and returns no
results. If I qualify the column as publicview.partno I get the error,
but I have to qualify it to get the error. Anyone see this before?
Running Oracle 7.2
Please e-mail me directly at
WHERE table1.Partno NOT IN
(SELECT partno from publicview)
doug.moloney_at_ae.ge.com
Thanks
Doug
Received on Fri Dec 06 1996 - 00:00:00 CET