List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 18 1999 6:23pm
Subject:Re: help with expression (except) and (NOT IN)
View as plain text  
At 1:17 PM -0500 4/18/1999, Mikkel Larsen wrote:
>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;


MySQL doesn't support subselects yet.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
help with expression (except) and (NOT IN)Mikkel Larsen18 Apr
  • Re: help with expression (except) and (NOT IN)Paul DuBois18 Apr