Not in one query tag without cooperation on the database management system's end.
I have in the past, used QofQ to combine data from multiple <cfquery...> result sets. My first choice though is to get the databases set up so that they are talking to each other, then one can easily query data from multiple data sources through one <cfquery...> tag connecting through one data source name. How one gets the databases to talk to each others depends on many factors such as DBMS, network and other considerations. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286495 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
