I have a number of records I need to update from another table. For some reason, it doesn't work.
UPDATE BILLING_PERIOD SET BILLING_PERIOD.BILLING_MONTH = (SELECT BILLING_MONTH_YEAR.BILLING_MONTH from BILLING_MONTH_YEAR where ID = 1), BILLING_PERIOD.BILLING_YEAR = (SELECT BILLING_MONTH_YEAR.BILLING_YEAR from BILLING_MONTH_YEAR where ID = 1)
WHERE BILLING_PERIOD.BILLING_MONTH is null;
BILLING_MONTH_YEAR is a one-record table, but would be updating multiple records in BILLING_PERIOD, which I want to update with all the same values. For some reason the query above gives me an "Must be an updateable query" error even though there's no aggregation. Can someone suggest how I can update this to work?