At 2:18 PM +0300 2000-04-05, sinisa@stripped wrote:
>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
Isn't this one of those LEFT JOIN situations?
SELECT tab1.col1 FROM tab1 LEFT JOIN tab ON tab1.col1 = tab2.col1
WHERE tab2.col1 IS NULL;
This assumes that tab2.col1 is defined as NOT NULL in the table
definition, though.
--
Paul DuBois, paul@stripped
