Is it possible to do a Sub-Select as a Global Data Constraint within a Business Table?

[BT_TABLE1.BC_COLUMN1] IN (SELECT BT_TABLE2.BC_COLUMN2 FROM BT_TABLE2)

PME 4.5; Windows; MySQL DB