>Thanks much for your answer Greg, but in my case I am using the view designer,
>it takes care of that, any other thoughts ?
>
>>I haven't tried it myself but I might try being explicit when naming the tables with their databases such as:
>>
>>SELECT tbl2.descr, tbl1.*;
>> FROM db1.dbo.tbl1 join db2.dbo.tbl2;
>> on db1.dbo.tbl1.id = db2.dbo.tbl2.id

Why not set up a view on the Server side that joins the data for you and then simply access the view with a VFP Remote view?