posted 17 years ago
I know the subject doesn't help much, bear with it please.
Here is hte scenario.
I have a table mytable with five userID fields user1,user2,user3 etc.
I have the actual users table with fname and lname (firstname,lastname)
what is the best query to bring the user names for a given record in MYTABLE ?
Should I do a left join five times??? ( sometimes user1,user2,user3 etc can all be the same id values. ) Or should I do five single queries to get the user names?
I am using MSSQL
Thanks for your time.
Brian