[AccessD] Delete Query with a join

David: get anywhere?
On Aug 28, 2014 10:40 PM, "Bill Benson" <bensonforums at gmail.com> wrote:

> Try
>
>    DELETE [rpt_DMHClaim 14].*
>    FROM [rpt_DMHClaim 14]
> WHERE Exists
>    (SELECT 1
>     FROM [qry 01a rpt_DMHClaim 14 Dupes to be > deleted]
>     WHERE [qry 01a rpt_DMHClaim 14 Dupes to be > deleted].ClaimNumber =
> [rpt_DMHClaim 14].ClaimNumber
> AND
>   [qry 01a rpt_DMHClaim 14 Dupes to be > deleted].MaxOfEOB_ID =
> [rpt_DMHClaim 14].EOB_ID)
>
> Action queries don't much like joins ad even distinctrow can lead to
> duplicates no? Not sure really.
>
> Got that here:
>
> http://stackoverflow.com/questions/5585732/how-to-delete-in-ms-access-when-using-joins
>