Re: NOT IN SQL command.

[Jeffrey Thompson]

If you have to do too much of the outer join you might consider redesigning 
your database to accommodate the selections where they join using indexes.

At 01:28 PM 4/4/00 -0700, you 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

Jeffrey Thompson
President
Thompson Internet Communications, Inc.
http://www.thompsonic.com/