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