I think if you run it you'll see why. Think of it this way, although that first table has a single record it's matched against each in the other table and any corresponding data, in this case the EmpID is also brought across. If it wasn't, the EMPID would be missing which isn't you'd expect either. But consider a situation where you have more than just EMPID.
... View more