I have 3 tables. We will say tblMaster, tblPayroll and tblString.

tblMaster has the following columns
EmpID
FirstNameID
LastNameID
MiddleInitID

the second table, tblPayroll has the following
EmpID, PayrollDescID

the third table, tblString has the following
StringID
StringText


in tblMaster, FirstNameID, LastNameID, and MiddleInitID all reference StringID, and look at the corresponding text in StringText.

What would be the best way to write the T-SQL?

So looking at the data, it may look like something like
FirstName = 1
LastName = 2
PayrollDescID = 3

in the String Table, the data is
1, Smith
2, John
3, Manager

So when i execute the tblMaster, i want to see John smith, Manager as the first row.