Tof
On 9/13/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
Are the databases on the same sql server? If so you can simply include the
database name as part of the query.
ie <dbname>.<dbuser>.<dbtable>
>
> Hi all
>
> I think I remember a post on this before but I can't find it anywhere.
>
> the app I'm extending uses 2 databases (2 diff DSN's). I now need to
> pull in data from both into the same recordset.
>
> eg:
>
> SELECT SCHED.StartDateTime, SCHED.EndDateTime, SCHED.Quiz_ID ,
> INST.AbsoluteSerialNum
> FROM tbl_Quiz_Schedule AS SCHED INNER JOIN
> evaluations.dbo.tbl_InstrumentReleased AS INST
> ON INST.>>
> I could:
> - use Query'o'query to combine 2 seperate queries into one (too much
> irrelivant data)
> - put the SQL onto one of the DB's as a SProc (back-up plan)
> - work out how to join the two databases within the same CFQUERY
> (preferred)
>
> any suggestions?
> thanx
> barry.b
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "cfaussie" group.
To post to this group, send email to cfaussie@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
