<B>CLASS CODE DESCRIPTION</B> Orientation H Horizontal Orientation V Vertical Orientation I Island Orientation S Square Geography F Full run Geography A A/B split Geography R Regional Size A Full Page Size B 1/2 Page Size C 1/4 Page Size D 1/8 Page Color 4 4 Colors Color 2 2 Colors Color 0 Black and WhiteNow, I need to build a table with CODE and DESCRIPTION field for each combination of 4 different classes. If my math is correct, I should have 144 records (4 Orientations X 3 Geography X 4 Sizes X 3 Colors). Both the CODE and DESCRIPTION field should contain "combined" data. An example of which would be: HFA4 (Horizontal, Full run, Full Page, 4 Colors). I'm looking for an "easy" SQL command to do this.