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.OnlineQuizID = SCHED.Quiz_ID
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 [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/cfaussie
-~----------~----~----~----~------~----~------~--~---
