Re: Join or Cross Product
From: Tom <trenfro_at_i-55.com>
Date: Sun, 25 Aug 2002 13:37:29 -0500
Message-ID: <akb7ss$3ae$1_at_news.datasync.com>
Date: Sun, 25 Aug 2002 13:37:29 -0500
Message-ID: <akb7ss$3ae$1_at_news.datasync.com>
chris.danx wrote:
>
> How do you use a nested query in SQL? (the schema is the same as in my
> first post).
>
>
> but that gives this rather unhelpful error in MySQL...
>
> ERROR 1064: You have an error in your SQL syntax near '(SELECT P.Number
> FROM Project AS P
> WHERE P.Name = 'ProductX'
> AND P' at line 3
>
>
MySQL doesn't yet support subselects (nested queries). It's slated for inclusion in MySQL 4.1 (a while away). Your queries should run fine in Postgresql (another free database), however.
HTH -Tom Received on Sun Aug 25 2002 - 20:37:29 CEST