SELECT Table1.Field1, TableA.Description, Table1.Field2, TableB.Description;
FROM Table1;
LEFTJOIN Table2 TableA ON Table1.Field1 = TableA.Code;
LEFTJOIN Table2 TableB ON Table1.Field2 = TableB.Code;
...
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller The only thing normal about database guys is their tables.