I create a left join - from tablea to tableb. I am having a reverse situation than a previous question asked - how can it be that i have fewer records in tablea after the join than before.
tablea has 100 records. i join on tableb on last name and first name, and now tablea indicates 90 records.
The join indicates to have all records in tablea, and only those in tableb that are a match to tablea.
Hope this makes sense.