SQL Cleanup set field value in one table from another

update franchiseeTable
set franchiseeTable .postal_code_territory_id= a.postal_code_territory_id
from franchisee_zips z
inner join
postal_code_territory a
on z.pid=a.tdg_pid

Comments

Popular posts from this blog

Linq - Data Entities - Records by Max Date with CASE

Excel download with Jquery using Table

Linq Remove from list based on other table