That sounds right...what I have it two totally different datasources; one I
have control over, and one I don't which is housed off site. The on off
site is on SQL, and because of the limited size and  usage on servers I
made the local one just access for ease. They both have a common table
called pid, and the one off site has all the human demension resources like
name and all that stuff. The other had their ID and files that are
associated with that pid. I want to have one out put and show the id, the
name and the filename all in one output. Would a union be the best way to
pull this off.

Thanks for all the help.

Seth

At 02:26 PM 2/21/2004, you wrote:
>Am I right in thinking you have two queries with the same column names and
>you want to combine the two and output it? If so, have a look at using UNION
>with your QofQ. See if that works.
>
>Ade
>   -----Original Message-----
>   From: Seth Kovanic [mailto:[EMAIL PROTECTED]
>   Sent: 21 February 2004 21:18
>   To: CF-Newbie
>   Subject: Re: Grabbing information from two different tables in two
>different datasources
>
>   Ubqtous,
>       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]

Reply via email to