> This works to combine two Access datasources into one query. > http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914
Eh oh, that tells you how to query 2 TABLES not 2 datasources! You can query 2 datasources in Access using the following technique however: SELECT tableA.field1, tableA.field2, tableB.field1 FROM someTable tableA, "D:\databases\foo.mdb".someOtherTable tableB WHERE tableA.field1 = tableB.field1 At least you could last time I tried it which was sometime in 1999, MDAC updates _may_ have changed matters but try it anyway. Steve -----Original Message----- From: Joseph Thompson [mailto:[EMAIL PROTECTED]] Sent: 01 November 2001 17:07 To: CF-Talk Subject: Re: Question about using 2 datasources > Ok heres my problem. > > I have a Access database that our users can go into and register new > studetns with. However all of our course information resides in another > datasource. My problem is that I have to display the course names which > reside in database 2. however I have to use the course ID's stored in > Datasource 1. How can I dothis? > > Thanks for all your help > > Kris Pilles > Website Manager > Western Suffolk BOCES > 507 Deer Park Rd., Building C > Phone: 631-549-4900 x 267 > E-mail: [EMAIL PROTECTED] > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
