You can create Linked servers in ms sql. I'm not sure if you could do that to a fox pro database. The caveat is linked severs suck performance wise. You could use query of queries in cold fusion to accomplish your task, however be careful that the original two query record sets are not so large that they crash cf.
-----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Thursday, September 28, 2006 11:52 AM To: CF-Talk Subject: Re: Inner Join Across Two Data Sources? How do you setup the link between MS SQL and FoxPro? Seems like that is the only way that could be done in a single query. On 9/28/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > Should be able to. Reference the fields like so: > > SELECT dt.fieldname > FROM database1.table1 d1t1 > INNER JOIN database2.table1 d2t1 > ON d2t1.id = d2t1.id > > <!----------------//------ > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > -----Original Message----- > From: Tim Claremont [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 28, 2006 11:15 AM > To: CF-Talk > Subject: Inner Join Across Two Data Sources? > > > I have two databases. One is in SQL Server, and the other is in FoxPro. > > Can I perform a single CFQUERY that includes one table in each data source > and joins the two based on say... ClientNum? > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254676 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
