Re: HOW TO CONVERT ORACLE TO MYSQL

[Roland Bouman]

like in all rdbms-es:

select ...
from ...
where col1 not in (
select somecol1
from sometable
)
and (col2,col3) not in (
select somecol2,somecol3
from sometable
)
and col4 not in ('a','b','c')


see:
http://dev.mysql.com/doc/refman/5.1/en/comparison-operators.html
and
http://dev.mysql.com/doc/refman/5.1/en/any-in-some-subqueries.html



Edited 1 time(s). Last edit at 03/09/2006 02:09PM by Roland Bouman.