SELECT ... Lookup1.descript as ABC, Lookup2.descript as XYZ, ... JOIN TheTable as Lookup1 ON... JOIN TheTable as Lookup2 ON...>My only question is - look at the first two JOIN commands and the last two JOIN commands. I am trying to lookup up a value in a table and translate a code in the table to a string of text. How do I use the same table to lookup a code for each field that needs translating from a code? Thanks ahead of time for the help.
