I am getting an error that states single-row subquery returns more than one row:

Unique_id and org_unit are integers

update main_t set unit_descr = (select unit_desc from org_units, main_t
where unit_descr is null and unique_id = org_unit)

Please help!

Thanks...