need sql help -- i want unique values with sum

Question

am creat view in sql sever based join querys with 4 tables    but am getting duplicate records with duplicate values     any only solve this issue     am giving my coding and tables and querys in attched with rar file

Nitin Sontakke · Accepted Answer

Can you please mention which duplicate values? Give some sample.   Typically the reason is join. However, I am almost certain the at least one of the group by column must be different.   Please show out you are getting.

Kumaran P · Answer

sir,  i attached my summary with sql table value there is difference is there in values column for sales double time sum the values for the sql code pls help the same

Nitin Sontakke · Answer

I had a look at the attachment. Where are the duplicates? I am not seeing any duplicates. Please clarify.

Kumaran P · Answer

Thank u sir for ur reply    here with am attached example for above sql code