Which field / scenario are you looking at ?
I can't see that a left join is creating duplicates, if you switch to an inner join you get the same result because in the Claims table there's 1 record for [Claim ID] = 1 and in [Work Order] there's 2 records for [Claim ID] = 1. So that's exactly how you'd expect it to behave.
Hi Chris. I mean it's cretating duplicate fields (columns).
1 of 1 people found this helpful
Ah, so [Claim ID] is there twice ? .. once from the Claims table and once from the Work Order table ... simply hide one of the fields, because both hold the same values all the time.