Column name for a SELECT obtained from an inner SELECT.

[cjard]

ultimately if you have a number of tables where the column name changes.. then the design is wrong.. those should be rows, with a column called "type_of_unit"