>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.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope