You may need to set up aliases in BDEConfig. That's how we've always got
heterogeneous queries to work.
Max
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mike Osborne
Sent: Friday, 22 October 1999 13:14
To: Multiple recipients of list database
Subject: Re: [DUG-DB]: Querying 2 tables from different database names
Thanks for the tip, however I experience an error saying
Invalid use of keyword on the database name I've defined.
Does anybody know what I am doing wrong.
I have tried opening one database only .....
Select * from mydatabase:dossiers
and it comes up with the same error, however if I define the database name
in the sql databasename cell and remove mydatabase: from the sql it works.
Please help
Darren
You could try:
Select * from ":alias1:table1" t1, ":alias2:table2" t2 where t1.SomeID1 =
t2.SomeID2
That works for me.
Regards,
Mike
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
