Whats the database type your using? and are botht he databases on the same server?
-----Original Message----- From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] Behalf Of Barry Beattie Sent: Wednesday, September 13, 2006 10:52 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Querying across multiple databases 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 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 -~----------~----~----~----~------~----~------~--~---