I have a master table called MasterType of types of appliances - which contain the master id and description as follows:
TypeID - Int [Primary Key]
I have another table called AppMaster that has 10 fields:
appType1 ... appType10
I want to output the Desc field from MasterType for each appType[x] in AppMaster. Do i have to do a left outer join 10 times on the AppMaster table for each appType? Isn't there a way to utilize the MasterType table one time to accomplish this?
I hope i've made sense here! If not, i can calrify.