This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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. Order Addres...
In the screenshot, I need to add a new row in table “Invoice” which has
a REF column to “Order” table. So I need to assign a value in the REF
column “Order Id” of the Invoice table. How should I do it here? Thanks
for advice.