>Can I have a view in VFP using SQL remote view data and VFP data?
>
>I have SQL table A with primary key ID (integer).
>
>I have VFP table with key XID (integer)
>
>I want a join that shows any record in A that is NOT in B

Does

SELECT * FROM a WHERE id NOT IN (SELECT xid FROM b)

do the trick???