How can I add units to a field name?

Hello,
I have 2 tables:
a) T1 with fields F1, F2, F3 and
b) T2 with fields and data like:

      FieldName             Units
      ----------------            --------
            F1                      U1
            F2                      U2
            F3                      U3

How can I create a view similar to T1 but with field names like: F1(U1), F2(U2), F3(U3)
based on T1 and T2 , using SELECT statement? Received on Thu Dec 09 1999 - 17:08:24 CST