guys,trying multiple updates without success like so:
update aset number = any ( select number from b where a.number=b.number)where number is null;>> 'syntax error at or near "any"'
subquery returns more than one row. using 8.1.thks, jzs