SQL Query

[jaygeemack]

I am using VFP9, and have a problem with SQL.

I have two cursors with identical structures. Each table has a unique field, p_key. I want to find the records which are in cursor1, but not in cursor2, based on the value of p_key.

Any ideas?

TIA

James McKelvie

 

[JRB-Bldr]

SELECT *;
   FROM Cursor1;
   WHERE P_Key NOT IN (SELECT DISTINCT P_Key FROM Cursor2)

Good Luck,
JRB-Bldr

 

[jaygeemack]

Thanks, jrbbldr, it worked a treat.

James