List:General Discussion« Previous MessageNext Message »
From:Mikkel Larsen Date:April 18 1999 6:17pm
Subject:help with expression (except) and (NOT IN)
View as plain text  
What is wrong with this expression?
 
select shows_id,row,seat from reservations where username=john and shows_id,row,seat not
in (select shows_id,row,seat from payments where username=john);
 
Or this one?
 
select shows_id,row,seat from reservations where username=john and shows_id,row,seat
except select shows_id,row,seat from payments where username=john;
 
Regards Mikkel Larsen
Thread
• help with expression (except) and (NOT IN)Mikkel Larsen18 Apr
  • Re: help with expression (except) and (NOT IN)Paul DuBois18 Apr