I want to add a virtual column ‘Zone’ in ‘Order’ table where the value is derived from ‘Zone’ column in a reference table ‘Allocation’; based on the condition that the ‘Postal code’ fits the postal code range in the reference table. E.g.
Zone <<< virtual column
Postal Code From
Postal Code To
What is the expression to use for the virtual column?