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