Please offer why in the following scenario
I have two tables - Table1 and Table2. Table1 originally has 100 records. However, when Ieft outer join with Table2 - this number increases to 110.
What I am trying to understand - is that if I am requesting to only return all in Table1, and those that match in Table1 and Table2 - the number should remain at 100 - since this was the original record count for Table1.