Re: Sqlplus: Embedded update statement

>I have two tables, call them "order" and "header",
>and they both have two columns called "value_id" and "lead".
>
>I want something like:
>
> update header.lead, setting header.lead = order.lead
> where header.value_id = order.value_id
>
Here follows a proposition:

	update header 
		set lead=(
				select order.lead 
				from order 
                where order.value_id=header.value_id
		)
	where value_id in (select value_id from order);

Claire Received on Fri Feb 12 1993 - 16:32:55 CET