Re: Trying to do a set difference

2001-08-24 Thread Werner Stürenburg
t;To: [EMAIL PROTECTED] >>From: Lindsay G Mccracken <[EMAIL PROTECTED]> >> >> Trying to do a set difference, >>select * from staff where NOT IN (select * from Supervises where Role='0' ); >>Can't seem to get it to work, is there a differe

Trying to do a set difference

2001-08-24 Thread Lindsay G Mccracken
>Date: Thu, 23 Aug 2001 17:39:14 +0100 >To: [EMAIL PROTECTED] >From: Lindsay G Mccracken <[EMAIL PROTECTED]> > > Trying to do a set difference, >select * from staff where NOT IN (select * from Supervises where Role='0' ); >Can't seem to get it