Dear Sir,
How to update master table to transaction table like sample
table1 is master table jobid,code,name
table2 is trans table jobid,orderdate,rate,code
jobid is same i want update code trans table values from master table
can you give update query
Loading
Pravin MorePosted Dec 29, 2011, 1:36 AM
hi manuel,
here is query
update table2 set code=table1.code
from table1 join table2
on table1.jobid=table2.jobid
Thanks,
Pravin.