Q: What is the difference between and INNER JOIN and an OUTER JOIN? Assume that you have two tables Table 1 and Table 2.
A: An inner join gets data from both tables where the specified data exists in both tables. For example:
An outer join gets data from the source table at all times, and returns data from the outer joined table ONLY if it matches the criteria.
0 Comments