you can try thisdeclare @People table (ID int, name varchar(20))declare @PeopleComboBoxesValues table (ID int, ComboBoxID int, Value varchar(20))declare @PeopleComboBoxes table (ComboBoxID int, ComboBoxName varchar(20))insert into @Peopleselect 1, 'Joe' union allselect 2, 'John' union allselect 3, 'Jeff'insert into @PeopleComboBoxesselect 1, 'Color' union allselect 2, 'Height' union allselect 3, 'Number'insert into @PeopleComboBoxesValuesselect 1, 1, 'Red' union allselect 1, 2, 'Tall' union allselect 1, 3, '3' union allselect 2, 1, 'Green' union allselect 2, 2, 'Medium' union allselect 2, 3, '3' union allselect 3, 1, 'Red' union allselect 3, 2, 'Medium' union allselect 3, 3, '3' declare @User varchar(10)set @User = 'Joe'select p.name, cb.ComboBoxName ,cbv.Valuefrom @People p inner join @PeopleComboBoxesValues cbv on p.ID = cbv.ID inner join @PeopleComboBoxes cb on cbv.ComboBoxID = cb.ComboBoxIDwhere p.name = @User