UPDATE mal_merch a,mal_specs_lot b
set a.specs_id = b.id
where a.merch_cls = '0105' and isnull(a.specs_id)
and b.merch_cls_no = '0105' and a.merch_cls = b.merch_cls_no
UPDATE mal_merch a,mal_specs_lot b
set a.specs_id = b.id
where a.merch_cls = '0105' and isnull(a.specs_id)
and b.merch_cls_no = '0105' and a.merch_cls = b.merch_cls_no