Re: SQL - Should produce an error and doesn't, please help.

Probably because partno is a valid column in table_1. it's selecting partno from table_1 where partno NOT in select partno (here it's taking from table_1). hence you will never get any results.

Qualify it. Runs slightly faster that way anyway.

hth

Doug Moloney wrote:
>
> SELECT PartNo FROM table_1
> WHERE table1.Partno NOT IN
> (SELECT partno from publicview)
>
> 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
> doug.moloney_at_ae.ge.com
>
> Thanks
> Doug
Received on Fri Dec 06 1996 - 00:00:00 CET