Insert rows in table if not found in another table

Question

I have a table:

Employee (employeeID)
EmployeeRank (rankID, employeeID)

Now I have another table that has all the employee's that are going to get a raise.

DueForRaise (rankID, employeeID)

I have to insert all the employees that are in DUeForRaise into the EmployeeRank table ONLY if they are not already there with the same rank.

I am doing this update for a particlar rankID, @rankID.

Would this work?

INSERT EmployeeRank ( rankID, employeeID)
SELECT rankID, employeeID
FROM DueForRaise dfr
      OUTER JOIN EmployeeRank er er.employeeid = dfr.employeeid)
WHERE dfr.rankID = @rankID

Answer 1

How about:

insert into EmployeeRank
select * from DueForRaise p
where NOT EXISTS(
    SELECT * FROM EmployeeRank WHERE rankID=p.rankID and employeeID=p.employeeID
);