shabeer shaik

shabeer shaik

  • NA
  • 40
  • 19.3k

how to update from 1 table to another

Dec 27 2012 10:40 AM
hallo Vulpes

I have a table in sql called tb1
the contents is something like this:
crse   dist   wintime   winweight
cd      1400    67.6       60
cd      1600    71.2       58
sv      1400     69.0      59

in tbl2 in sql
crse    dist     partime    winweight
cd       1400    
cd       1600  
sv        1400

I WANT TO AUTOMATICALLY UPDATE TBL2 PARTIME,WINWEIGHT WITH WINTIME ,WINWEIGHT FROM TBL1 WHERE CRSE AND DIST ARE THE SAME.


 

Answers (5)