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.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 -~----------~----~----~----~------~----~------~--~---