![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)
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? :
![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)