Problem with subqueries

2002-07-31 Thread Luis Rodrigues
ot;LocalidadeP"]&' ... WHERE Referencia NOT IN ( SELECT Referencia FROM historico_clientes WHERE NumCliente=$id) Best Regards, Luis Rodrigues - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Problem with subqueries

2002-07-31 Thread Luis Rodrigues
Thanks. On 31 Jul 2002, Martin Waite wrote: > On Wed, 2002-07-31 at 12:03, Luis Rodrigues wrote: > > hi, > > I have some sql code that I need to use with mysql > > it uses nested queries and since mysql doesn't implement them > > I would like to know how to