OK.  Got it working with your suggestions.  However, I've got one more twist... if you don't mind.  This should cover all my bases on this query.

An employee's rate might change...

Thanks, everyone, for your help / suggestions.  I'll give them a try later tonight / tomorrow.

FYI, here's some sample data:

Employees

empID     empName

----------------------

10        Josh

11        Bob

Projects

projID    projName

----------------------

20        Project A

21       ...