I think heterogenous joins are done with something like...
SELECT
A.ID,B.DESC
FROM
DB1:TableA A,
DB2:TableB B
WHERE
A.ID=:ID AND A.SUBID=B.SUBID
I think this requires having a database param set to local SQL handling rather than
server
so that the BDE can resolve the SQL and prepare a local temporary table for the join...
--
Aaron Scott-Boddendijk
Jump Productions
(07) 838-3371 Voice
(07) 838-3372 Fax
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
