Why don't you try it yourself? That's the best way to learn. It's also much faster than waiting for replies on mailing lists ;-)
Also, when you send a note like this about SQL, you should indicate which version of MySQL you are using; different versions have different capabilities. For example, only 4.1.x versions permit subqueries. Rhino ----- Original Message ----- From: "Gabriel Alessandria" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 04, 2004 9:07 AM Subject: Sintax - Where xx not in (another Select structure) > There exists the possibility of doing a SELECT where the list of IN() clause > is the result of another select ? > > Like this for example > > > Select Number from Phone where Number not in > ( > SELECT Number from Vendor, Clients > where Vendor.Number=Clients.Number > ) > > > Thank in advance > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]