SQL Server Multiple Field Join
Posted on 2012-03-28
I have 2 tables with data. My Contract table stores an address along with 3 ID numbers. These 3 ID numbers reference names that are stored in another table. How can I perform a join to retrieve the details?
I have tried an inner join as below but this only gives me 1 of the 3 fields I need:
'SELECT c.*, s.* FROM tbl_ContractDetails c INNER JOIN tbl_Staff s ON c.ContractManagerID = s.ID WHERE JobNo = 807'
I need to join the 2 other fields from the Staff table to the query.
Any help is appreciated