I have two tables join together, and I want
to exclude records that are inside another
table.
eg.
select .... from loc,inv,ser
where invloc = locnam and locnam NOT IN
(select serloc from ser where sernum >50 and
sernum<100)