On Wed, 1 Sep 1999, Ricardo Cruz wrote:
>Your Asking Page is so much complex!!
>
>I only would like to know, how can I write this sentence in MySQL SQL Language:
>
>SELECT t1.field1
>FROM table1 t1
>WHERE t1.field1
>NOT IN (SELECT t2.field2 FROM table2)
>
>I´m feeling that MySQL SQL Language don´t accept statements as parameters
> in
>the function IN.
>
MySQL doesnot support embedded SELECT's at this time. Which is why the
statement you are trying doesn't work
They are working on it.
Slan,
Micheal
---
Micheal Mc Evoy mjmc@stripped
http://www.whitepine.com
WhitePine Consulting supports the Free Software Foundation and it ideals
by promoting, using and supporting Open Source, GNU and GPL'd Software.
