麻烦找找这段语句的错误.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/11/23 11:57:14
麻烦找找这段语句的错误.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