In this example, you will first create an inner join that relates employee identification number and salary. Then, you will create an outer join that combines this data with data from another table to ...

It’s concerning that issue of re-using identifiers and re-using employee ID numbers. At the risk of further muddying things, let’s take a final look (for now) at the issues.