![sql server - How do I get the sum of a field and avoid duplication from an inner join? - Database Administrators Stack Exchange sql server - How do I get the sum of a field and avoid duplication from an inner join? - Database Administrators Stack Exchange](https://i.stack.imgur.com/CCzgi.png)
sql server - How do I get the sum of a field and avoid duplication from an inner join? - Database Administrators Stack Exchange
![sql server 2008 r2 - How get the sum of two tables value using inner join - Database Administrators Stack Exchange sql server 2008 r2 - How get the sum of two tables value using inner join - Database Administrators Stack Exchange](https://i.stack.imgur.com/Cp7om.png)
sql server 2008 r2 - How get the sum of two tables value using inner join - Database Administrators Stack Exchange
![SQL Puzzle | Getting group by sum and total sum in a single query [with Multiple Solutions – Best One] | Improving my SQL BI Skills SQL Puzzle | Getting group by sum and total sum in a single query [with Multiple Solutions – Best One] | Improving my SQL BI Skills](https://pawankkmr.files.wordpress.com/2016/07/execution-plans-getting-group-by-sum-and-total-sum-in-a-single-query-multiple-solutions-best-one-msbiskills-com.jpg)
SQL Puzzle | Getting group by sum and total sum in a single query [with Multiple Solutions – Best One] | Improving my SQL BI Skills
![I don't understand the difference between inner join and self join. The result of the following SQL is the same. If they are the same, is there any need for inner join? : I don't understand the difference between inner join and self join. The result of the following SQL is the same. If they are the same, is there any need for inner join? :](https://preview.redd.it/7wmp7kovvuy81.png?width=837&format=png&auto=webp&s=a975b885a1cc0424d1c923af1fb192e680b8c2aa)