CF doesn't have any problem joining multiple databases, it's more likely that the problem is with the ODBC driver. Could be a lot of things though.
What is the error that CF throws? -- jon mailto:[EMAIL PROTECTED] Thursday, August 15, 2002, 9:29:51 AM, you wrote: BS> Thanks but the database names are in the query: MSHAREA and MCASA. BS> Date: Wed, 14 Aug 2002 13:36:27 -0700 BS> From: Tim Do <[EMAIL PROTECTED]> BS> To: BS> Subject: RE: Joining tables across 2 DB2 databases BS> Message-ID: BS> <[EMAIL PROTECTED]> BS> try putting dbname..table name BS> -----Original Message----- BS> From: Bhandari, Sona [mailto:[EMAIL PROTECTED]] BS> Sent: Wednesday, August 14, 2002 1:28 PM BS> To: CF-Talk BS> Subject: Joining tables across 2 DB2 databases BS> I'm currently running the SQL below on the mainframe against a two DB2 BS> databases and it works fine. However, when I run the same BS> query in COLD FUSION, it hangs up. Can Cold Fusion handle joining 3 tables BS> across two DB2 databases even with the same datasource? Could there be BS> something wrong with my query? Thanks for your help. BS> SELECT COUNT(A.ALPHA_POSN_CD), C.OCD, A.ALPHA_POSN_CD BS> From MSHAREA.HRPOSNRF A, MCASA.TA B, MSHAREA.TKNUMRF C BS> Where A.HR_POSN_CD = B.HR_POSN_CD and BS> B.TKNUM = C.TKNUM and BS> A.ALPHA_POSN_CD IN ('01', '02', '03', '04') and BS> C.OCD IN ('A01', 'E99') BS> Group by C.OCD, A.ALPHA_POSN_CD; ______________________________________________________________________ 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
