>hi
>
>how can I write this query in MS access in vfp
>
>DELETE DISTINCTROW claim_detail.*
>FROM [claims 02] INNER JOIN claim_detail ON ([claims 02].LINE = claim_detail.LINE) AND ([claims 02].CLAIM_NUM = claim_detail.CLAIM_NUM);
>
>
>bhushan

I will take a shot:

DELETE from claim_detail
WHERE LINE+CLAIM_NUM IN (SELECT DISTINCT LINE+CLAIM_NUM from claims02)


Given that Claim_Detail is the table to delete from and Claims02 is the table used to check for data.