Tim Stutzman wrote: > Hi, > > The SQL Server has all the fields I need but one field that is in the DB2 > database. I need to join between the two databases, but I have never wrote a > query that uses two different data sources.
You can not connect to to different data sources in a single query. If one of the database servers can see the other, you can reference them both inside the query with fully qualified names. SELECT ... FROM aDatabase.aUser.aTable Otherwise in ColdFusion you can select the required information from each database with a seperate query block then combine the two block with a query-of-query or manually using the query functions; queryNew(), queryAddRow(), querySetCell(), etc. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312467 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
