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 |
|
matkwan
Starting Member
36 Posts |
 Posted - 2002-12-30 : 21:21:34
|
| Hi, I am trying to bring the values from tbl_B to tbl_A using the following SQL, but Access won't execute the SQL, it said "Operation must use an Updateable query".Update tbl_A set tbl_A.StockBalance = (Select tbl_B.StockBalance from tbl_B where tbl_A.ItemCode = tbl_B.ItemCode)Matthew |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2002-12-31 : 00:20:00
|
| UPDATE tbl_A INNER JOIN tbl_B ON tbl_A.ItemCode = tbl_B.ItemCode SET tbl_A.StockBalance = tbl_B.StockBalance; |
 |
|
|
|
|
|
Please correct my Update SQL