4,011
社区成员
发帖
与我相关
我的任务
分享ACCESS同一数据库的两个表,求“一个表的某个记录中的某个字段更新为另一个表中某个记录的两个字段运算后的值"的SQL语句 （参与有分）
比如有表a,b.
更新a.total = b.price * b.number
更新a.total = b.price * b.number
...全文
请发表友善的回复…
发表回复
tangzhg 2003-11-12
- 打赏
- 举报
select price,Number from b
update a set total= b.price * b.number
update a set total= b.price * b.number
yoki 2003-11-11
- 打赏
- 举报
update a ,b Set total = b.price * b.Number where a.id=b.id
yoki 2003-11-11
- 打赏
- 举报
Dim cn As New ADODB.Connection
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=c:\db.mdb"
cn.Execute "update a ,b Set total = b.price * b.Number where a.id=b.id"
cn.Close
Set cn = Nothing
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;data source=c:\db.mdb"
cn.Execute "update a ,b Set total = b.price * b.Number where a.id=b.id"
cn.Close
Set cn = Nothing
crystal_heart 2003-11-10
- 打赏
- 举报
INSERT INTO a SELECT b.price * b.number FROM b
UPDATE a SET Total = b.price * b.number
FROM a INNER JOIN b ON a.xxx=b.xxx
UPDATE a SET Total = b.price * b.number
FROM a INNER JOIN b ON a.xxx=b.xxx
