Enum from enum list

[ahmed_almulla]

I create enum list column in table (1)

Can I create enum for column in table (2) contain only the item choosen from the pevious enum list ??

[Kirk_Masden]

I think the answer is “yes.” If the values from the previous enum list have been recorded, you should be able to do that using SELECT() and/or perhaps other expressions.