Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
programer
Posting Yak Master
221 Posts |
 Posted - 2011-04-26 : 16:31:31
|
| Hi,I have tbl_table1:ID, Description, Amountand tbl_table2:ID, Description_table1, Amount_table1When I stored data in table1 "Description" and "Amount" is stored in the table2 data that I store in table1Like this:In table1 I stored description5, Amount 10Data from table1 automatically saves the data in table2edit: moved to proper forum |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
programer
Posting Yak Master
221 Posts |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-04-26 : 18:33:13
|
| You would have to UPDATE table2UPDATE t2SET Amount_table1 = t1.AmountFROM tbl_Table2 t2INNER JOIN tbl_Table1 t1ON t2.ID = t1.IDJimEveryday I learn something that somebody else already knew |
 |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-04-26 : 19:18:54
|
It has to be the start of a new semester somewhere.JimP.S. I got your full moon right here, buddy! Everyday I learn something that somebody else already knew |
|
|
|
|
|
|
Stored procedure INSERT INTO