Доброе время суток!
есть два запроса:
SELECT *
from inv_form im, temp_tbl2 t2
where im.producer_id = t2.id_new and
form_type_id IN (SELECT form_type_id FROM inv_form iv WHERE iv.producer_id = id_new)
and holding_id IN (SELECT holding_id FROM inv_form iv WHERE iv.producer_id = id_new)
и
UPDATE inv_form_param_value set form_id = im.id
from inv_form im, temp_tbl2 t2
where im.producer_id = t2.id_new and
form_type_id IN (SELECT form_type_id FROM inv_form iv WHERE iv.producer_id = id_new)
and holding_id IN (SELECT holding_id FROM inv_form iv WHERE iv.producer_id = id_new)
SELECT * выполняется а UPDATE нет!
В чем ошибка, пожалуйста помогите!