2000下应该没问题。97下可以先建个视图 t3
(select scode,sum(pds) as sum_pds from pandian group by scode) 然后:
SELECT bjkc.scode,bjkc.price,bjkc.inventory,t3.sum_pds,bjkc.inventory-t3.sum_pds as xx
FROM bjkc INNER JOIN t3 ON t3.scode = bjkc.scode
(select scode,sum(pds) as sum_pds from pandian group by scode) 然后:
SELECT bjkc.scode,bjkc.price,bjkc.inventory,t3.sum_pds,bjkc.inventory-t3.sum_pds as xx
FROM bjkc INNER JOIN t3 ON t3.scode = bjkc.scode
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货