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
