YEAP! ver. 4.1.x supports subselects. One thing i should say is that it is still in beta, but it seems to be quite stable! =)
Best Regards! On Thu, 2004-03-04 at 10:07, Gabriel Alessandria wrote: > 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 -- |...........................................................| |____ _____ ____ _ |Victor Medina M | |\ \ \| ____| _ \ / \ |Linux - Java - MySQL | | \ \ \ _| | |_) / _ \ |Dpto. Sistemas - Ferreteria EPA | | / / / |___| __/ ___ \ |[EMAIL PROTECTED] | |/_/_/|_____|_| /_/ \_\|ext. 325 - Tél: +58-241-8507325 | | |geek by nature - linux by choice | |...........................................................|