麻烦找找这段语句的错误.
来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/08/24 11:16:09
麻烦找找这段语句的错误.
UPDATE inv_trans_detail
INNER JOIN Sheet1 ON
inv_trans_detail.amt - Sheet1.amt =0 AND
inv_trans_detail.item_code = Sheet1.item_code AND
inv_trans_detail.bill = Sheet1.bill
SET inv_trans_detail.qty = Sheet1.r_qty,inv_trans_detail.amt = Sheet1.r_amt
WHERE inv_trans_detail.trans_type='O01' AND inv_trans_detail.warehouse='2' AND Sheet1.r_amt Is Not Null
这个语句提示INNER附近语法错误,请问这个语句那里错了?
UPDATE inv_trans_detail
INNER JOIN Sheet1 ON
inv_trans_detail.amt - Sheet1.amt =0 AND
inv_trans_detail.item_code = Sheet1.item_code AND
inv_trans_detail.bill = Sheet1.bill
SET inv_trans_detail.qty = Sheet1.r_qty,inv_trans_detail.amt = Sheet1.r_amt
WHERE inv_trans_detail.trans_type='O01' AND inv_trans_detail.warehouse='2' AND Sheet1.r_amt Is Not Null
这个语句提示INNER附近语法错误,请问这个语句那里错了?
更新语句 不能用inner join