>Hi. Using VFP7. Could someone please give me a select-sql statement for the following:
>
>"Every record in database B that is NOT in database A".
>
>Thanks, Randy

SELECT * FROM tableb ;
  WHERE keyfield NOT IN (select keyfield FROM tablea)