Re: help with expression (except) and (NOT IN)

[Paul DuBois]

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/