Left Join Duplication and Storing different tables
I need a solution about for my issue. I have joined two tables with below script but since PaidDate field record in joined table has 2 different records it makes duplication of Premium field after join. I would exclude Paid Date and get sum of claim amount and solve this problem but. I might use paid date field in other tables.
So how can pass a zero value for the duplicated premium field like writing in a condition if claimsID are same for the previous column value of premium field of this record should be zero ?
Or as a second solution can I keep the table with paid date field as a separate table in my data ?