On Friday, February 20, 2004, 5:12:43 PM, you wrote:
SK> Query Of Queries syntax error.
SK> Encountered "inner" at line 0, column 0.
You might try the other join syntax:
<cfquery dbtype="query" name="ds3">
select ds1.id, ds1.name, ds1.email, ds2.filename
from ds1, ds2
where ds1.id = ds2.id
</cfquery>
I know QoQ is limited in what it can do, so the above may not be
possible, regardless of syntax.
~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
