Still no dice. One thing that may be causing it is one datasource is in
SQL and the other is in access. That may be causing my problems.
Here is some code slightly modified...see if you see anything that grabs
you. The only thing I changed were table names and passwords and such. But
it is the exact same otherwise.
Thanks for all the help.
Seth
<cfquery datasource="ds1" username="u" password="p" name="main">
SELECT common.id, common.full_name
FROM csusa_common
</cfquery>
<CFQUERY datasource="ds2" name="mine">
SELECT filename, id FROM table1 ORDER BY id
</CFQUERY>
<cfquery dbtype="ds3" name="final">
select common.id, common.full_name, id, filename
from main, mine
where main.csusa_common.id = mine.id
</cfquery>
At 12:57 AM 2/21/2004, you wrote:
>Seth,
>
>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]
