From: Paul DuBois
Date: April 18 1999 6:23pm
Subject: Re: help with expression (except) and (NOT IN)
List-Archive: http://lists.mysql.com/mysql/2030
Message-Id: <v04020a13b33fd395206e@[192.168.0.5]>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"

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/