Bharat,

there was a discussion similar to this a week or two ago.

The final conclusion was that there cannot be a second table field involved in the WHERE that you expect to be handled in synchronization with the first table. In other words the field of the second table will stay on the same record throughout the operation.

However it was felt that there was some chance of achieving a desired result using a sub-select. Maybe you should play more with your sub-select.

good luck,

JimN

>I tried to run this query
>
>delete from claim_detail where;
>claim_detail.line = claims02.Line and;
>claim_detail.claim_num = claims02.claim_num
>
>This query seems to be running but does not delete the rows. I know this query should delete 140 records as this select query.
>
>select claim_detail.* FROM claim_detail, claims02;
>where claim_detail.line = claims02.line and;
>claim_detail.claim_num = claims02.claim_num
>
>returns 140 records. Actually these 140 records I want to delete from the claims_detail table.
>
>Thanks for your concern
>Bhushan