Getting enum text with join in flex query

Below example getting order status text.

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