November 18, 2004, 12:48 PM
InsideTGTCluster Join Question...
If I have 3 tables A/B/C, and want to do a 1-1 join from Table A to Table B, but also join uniquely to Table C by combining key fields that reside on Table A and Table B, is it possible to represent this in a cluster join? We're on version 5.26.
Thanks, Brad
November 19, 2004, 01:44 PM
TexasStingrayI have not tried it. But if are the table are from the same RDBMS (MS SQL, DB2, ORACLE, ..) you should be able to do this. Current the cluster join does not allow you to do cross RDBMS joins.