Select question

[bup]

I've got 2 tables named Proposal and Employee.&nbsp;&nbsp;Two of the fields in the Proposal table are last_modified_by and author.&nbsp;&nbsp;These fields are both linked to the field named emp_id which is in the Employee table.<br><br>Here's the question...&nbsp;&nbsp;How do I select a certain proposal and get the first and last names (these are also fields in the Employee table) of the last_modified_by and author from the Employee table in one single select statement?<br><br>Some help on this would really help me out!&nbsp;&nbsp;Thanks.

 

[Firozb]

Try this:<br><br>select last_mod, a.empName, author, b.empName from proposal, employee a, employee b<br>where last_mod = a.empID and author = b.empID<br><br>