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.
