Re: UPDATE COMMAND

Hope this will help.

Regards.

update

        table_1
set

	(table_1.field_to_update_1, 
	table_1.field_to_update_2, 
	..., 
	table_1.field_to_update_n)
=
	(select 
		table_2.field_with_value_to_copy_1, 
		table_2.field_with_value_to_copy_2, 
		..., 
		table_2.field_with_value_to_copy_n
	from 
		table_2
	where
		table_1.join_field_1=table_2.join_field_1
		and table_1.join_field_2=table_2.join_field_2
		and ...
		and table_1.join_field_n=table_2.join_field_n
	)
where
	table_1.update_condition_field_1=[some_value]
	and table_1.update_condition_field_2=[some_value]
	and ...
	and table_1.update_condition_field_n=[some_value]

D.D. <d.delisser_at_worldnet.att.net> a écrit dans l'article <85vfvo$9t1$1_at_bgtnsc01.worldnet.att.net>...
> I'm trying to update a table from another table. I do not want to copy
the
> complete table, but just update it with the new results from an existing
> table. How do I do this?
>
> Thanks,
> JD
>
>
>
Received on Wed Jan 19 2000 - 05:23:29 CST