This functionality exists in 4.1.x versions of MySQL >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 3/4/04, 8:07:15 AM, Gabriel Alessandria <[EMAIL PROTECTED]> wrote regarding 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]
