Y
_yzy_
Unregistered / Unconfirmed
GUEST, unregistred user!
SQL如下：
SQL.Add('UPDATE SockInfo INNER JOIN ITemp_Table ON SockInfo.C_ID = ');
SQL.add('ITemp_Table.C_ID SET SockInfo.Cost_price =');//下面是子查询
SQL.Add('(select ((select Sum(Total_Amount) from I_CList where I_CList.C_ID= ITemp_Table.C_ID)');
SQL.add(' +(select Sum(Total_Amount) from ITemp_Table))/((Select Sum(I_InputNumber) from ITemp_Table where I_InputNumber<>0)');
SQL.add(' +(select Sum(I_InputNumber) from I_CList where I_CList.C_ID= ITemp_Table.C_ID))');
SQL.add(' as CBJ from ITemp_Table)') ;
子查询已测试没有问题.数据库类型:Access
SQL.Add('UPDATE SockInfo INNER JOIN ITemp_Table ON SockInfo.C_ID = ');
SQL.add('ITemp_Table.C_ID SET SockInfo.Cost_price =');//下面是子查询
SQL.Add('(select ((select Sum(Total_Amount) from I_CList where I_CList.C_ID= ITemp_Table.C_ID)');
SQL.add(' +(select Sum(Total_Amount) from ITemp_Table))/((Select Sum(I_InputNumber) from ITemp_Table where I_InputNumber<>0)');
SQL.add(' +(select Sum(I_InputNumber) from I_CList where I_CList.C_ID= ITemp_Table.C_ID))');
SQL.add(' as CBJ from ITemp_Table)') ;
子查询已测试没有问题.数据库类型:Access