On Tue, 04 Apr 2000, 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
HI!
It is on our TODO list. For the moment you can replace the above with:
select tab1.col1 from tab1,tab2, where tab1.col1 != tab2.col1;
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
