What is the difference between inner and outer join? Technology Community › Category: SQL › What is the difference between inner and outer join? 0 Vote Up Vote Down VietMX Staff asked 4 years ago Inner join returns rows when there is at least one match in both tables Outer join will return matching rows from both tables as well as any unmatched rows from one or both the tables