Getting enum text with join in flex query

Below example getting order status text.

select {code}, {enumerationvalue:code}
from {order join enumerationvalue on {order:status} = {enumerationvalue:pk}}