Re: I'm baffled by this one.

Neil Brown <neil_at_nmb.u-net.com> wrote:
: I'm baffled by a unexpected responce from a simple query using Oracle
: 7 server version 7.3.2.3.2. It's this:
 

: Select item from tablea
: where item not in (select item from tableb)
: /
: Gives no data found. Where

try this:

where item not in (select tableb.item from tableb) Received on Tue Dec 23 1997 - 00:00:00 CST