以下是引用sdta在2013-6-7 10:57:37的发言：

同一编号有若干商品名称

以下是引用sdta在2013-6-7 10:46:13的发言：

商品名称与商品编号是否一一对应
同一商品怎么会有若干个编号

以下是引用TonyDeng在2013-6-7 12:13:44的发言：


你帮他做到底？

以下是引用wp231957在2013-6-7 08:42:57的发言：

SELECT SUM(dj*shl2) FROM (SELECT spbh,dj, SUM(shuliang) AS shl2 FROM liushuiw GROUP BY spmc HAVING shl2>0 into table T1)
SELECT SUM(dj*shl2) FROM (SELECT spbh,dj, SUM(shuliang) AS shl2 FROM liushuiw GROUP BY spmc HAVING shl2>0) into table T1
SELECT SUM(dj*shl2) FROM (SELECT spbh,dj, SUM(shuliang) AS shl2 FROM liushuiw GROUP BY spmc HAVING shl2>0) T1

以上诸条语句在vf6下均提示语法错误
比较闹心的是  如何才能让它提示哪里出错了呢  就笼统的一句语法错误