>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