Join Update

Update table with entries from other table, with join

update table
set 

	field1 = other_table.field1,

	field2 = other_table.field2

from table
	inner join other_table on other_table.field3=table.field3
This entry was posted in Uncategorized and tagged , . Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *