List:General Discussion« Previous MessageNext Message »
From:Micheal Mc Evoy Date:September 1 1999 9:45pm
Subject:Re: Doubt
View as plain text  
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.

Thread
DoubtRicardo Cruz2 Sep
  • Re: DoubtMicheal Mc Evoy2 Sep
  • Re: DoubtTonu Samuel2 Sep
  • RE: DoubtMike Robinson2 Sep
  • Re: DoubtRalph Graulich2 Sep
  • Re: DoubtThimble Smith2 Sep