At 18:19, 19990901, Ricardo Cruz wrote:
>I only would like to know, how can I write this sentence in MySQL SQL
>FROM table1 t1
>NOT IN (SELECT t2.field2 FROM table2)
>I´m feeling that MySQL SQL Language don´t accept statements as
>parameters in the function IN.
Hi, Ricardo. To accomplish the same thing without using sub-selects,
you can use a LEFT JOIN. Here is how:
FROM table1 t1 LEFT JOIN table2 t2 ON (t1.field1 = t2.field2)
WHERE t2.field2 IS NULL
MySQL will support sub-selects in version 3.23.24, which is still a
few months away.