TID PROD_DESC
1      A
1      C
2      B
4      Z

TID PROD_DESC GENDER STATE CLASS
 1      A        M      FL    Z
 1      C        M      FL    X
 2      B        F      TX    Y
 4      Z        F      GA    V