麻烦找找这段语句的错误.UPDATE inv_trans_detail INNER JOIN Sheet1 ON inv_trans_detail.amt - Sheet1.amt =0 ANDinv_trans_detail.item_code = Sheet1.item_code AND inv_trans_detail.bill = Sheet1.billSET inv_trans_detail.qty = Sheet1.r_qty,inv_tr
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/23 23:58:27
![麻烦找找这段语句的错误.UPDATE inv_trans_detail INNER JOIN Sheet1 ON inv_trans_detail.amt - Sheet1.amt =0 ANDinv_trans_detail.item_code = Sheet1.item_code AND inv_trans_detail.bill = Sheet1.billSET inv_trans_detail.qty = Sheet1.r_qty,inv_tr](/uploads/image/z/9990314-26-4.jpg?t=%E9%BA%BB%E7%83%A6%E6%89%BE%E6%89%BE%E8%BF%99%E6%AE%B5%E8%AF%AD%E5%8F%A5%E7%9A%84%E9%94%99%E8%AF%AF.UPDATE+inv_trans_detail+INNER+JOIN+Sheet1+ON+inv_trans_detail.amt+-+Sheet1.amt+%3D0+ANDinv_trans_detail.item_code+%3D+Sheet1.item_code+AND+inv_trans_detail.bill+%3D+Sheet1.billSET+inv_trans_detail.qty+%3D+Sheet1.r_qty%2Cinv_tr)
麻烦找找这段语句的错误.UPDATE inv_trans_detail INNER JOIN Sheet1 ON inv_trans_detail.amt - Sheet1.amt =0 ANDinv_trans_detail.item_code = Sheet1.item_code AND inv_trans_detail.bill = Sheet1.billSET inv_trans_detail.qty = Sheet1.r_qty,inv_tr
麻烦找找这段语句的错误.
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 ANDinv_trans_detail.item_code = Sheet1.item_code AND inv_trans_detail.bill = Sheet1.billSET inv_trans_detail.qty = Sheet1.r_qty,inv_tr
更新语句 不能用inner join