>The table is part of a database. I know the second syntax you give and using that syntax I get a result but that doesn't solve my original problem (combine 2 sql tables and 1 VFP table on a linked server)
Hi Hans,
We've two issues here:
1. Four part name for a VFP table in DBC
I just tested and it works for me. The linked server is setup with Provider string only
DRIVER={Microsoft Visual FoxPro Driver};
Exclusive=No;Collate=Machine;Deleted=Yes;Null=No;
SourceDB=\\Target_1\vol_1\daily\lccqueue\testdbc.dbc;SourceType=DBC;
I would suggest that you play more with it and try to figure out why it doesn't work for you.
2. Using OPENQUERY() in 3 table join
You didn't say what the problem is but the following works for me
SELECT * FROM pubs.dbo.authors au
JOIN (SELECT * FROM OPENQUERY(testdbc, 'SELECT * FROM test1')) vt
ON au.au_id = vt.cc
--sb--