Pulling in employee names based on emp #

1

I'm having a brain fart here.

I have an inventory transaction table I'm reporting against and am pulling in 6-8 fields. That inventory transaction table has the emp # but no names. I'm joining the inventory transaction table on the emp master table that does have their names, joining by emp #.

What do I need to do to pull in the names from emp master instead of emp # from the inventory transaction table?

Hope that makes sense.

2

Select the 8 columns from inventory and names from employee joined on emp #.

SELECT i.*, e.FirstName, e.LastName
FROM
 INV i
JOIN
 EMP e ON i.Empid=e.Empid;
3

Hello,

Thanks for the reply.

I tried that and the query runs but the first and last name are blank, nothing is pulling in.