Quote:
that is "one chained dictionary table <- many fields"
You need two JOINs, one for each column in the original table:
SELECT d1.field_description AS Field1, d2.field_description AS Field2 FROM Table_data t
JOIN Table_dictionary d1 ON t.field1 = d1.field_code
JOIN Table_dictionary d2 ON t.field2 = d2.field_code