Sep 2nd, 2012, 08:47 AM
I have 3 tables. We will say tblMaster, tblPayroll and tblString.
tblMaster has the following columns
the second table, tblPayroll has the following
the third table, tblString has the following
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
So when i execute the tblMaster, i want to see John smith, Manager as the first row.