Hi, I'm using Delphi XE with the adodataset to query sql database but I'm now encountering a new situation where I have to query on two different serveurs. Separatly I can query them but if I want to make a joined query then I'm not sure how to do this since adodataset have only one adoconnection specified.
For exemple, I would lke to query this
select * from customer left join mytable on customer.id=mytable.idcust
Here the customer table and mytable are on two different serveur.