From: Steve Ruby
Date: April 4 2000 6:17pm
Subject: Re: NOT IN SQL command.
List-Archive: http://lists.mysql.com/win32/2024
Message-Id: <38EA31D3.497733B9@rubysolutions.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Read the manual regarding subselects, see the "todo" list.

http://www.mysql.com/Manual_chapter/manual_toc.html

Shail Dahal wrote:
> 
> Can we have similar command in mysql for this
> 
> select col1 from tab1 where col1 NOT IN (select col1 from tab2);
> 
> TIA.
> 
> --Shail Dahal
> 
> Shail Dahal
> 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread2022@stripped
> 
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.