As far as I know, this isn't possible. What is possible is doing two seperate queries and making your own dataset with either QueryNew() or building a structure. Can you give us some more information?
Sharon ----- Original Message ----- From: "Robert Everland" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, March 26, 2002 11:15 AM Subject: Join up datasources > Is it possible to have a query where you don't specify a datasource > and then inside of the query join up more than one datasource. Something > like this > > <cfquery> > Select DSN.Database.Table.Row, > differentdsn.database.table.row > From dsn.database.table, > differentdsn.database.table > > </cfquery> > > Robert Everland III > Dixon Ticonderoga > Web Developer Extraordinaire > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
