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 do this.
> >
> > SELECT * FROM apart
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 do this.
>
> SELECT * FROM apartamentos
> WHERE vendido=0
> AND Concelho=$row["ConcelhoP"]
MySQL does not support sub-queries. Take a look at JOINS
(http://www.mysql.com/doc/J/O/JOIN.html)
- Original Message -
From: "Luis Rodrigues" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 31, 2002 6:03 AM
Subject: Problem with subqueries
hi,
I have some sql code that
