Thanks.
Can I select the non-duplicated record like this?
SELECT case_no from table_a Where case_no NOT IN (select case_no from table_b) into cursor dup_record
Best regards,
Aaron Chu
********************************************************
Working with Visual FoxPro is a lot of FUN!
********************************************************