use tpimis
select a.no_goods,'9999999','2',a.price_sale,'[','2010',']',a.article,'[!]',b.na_factory
from syb_zdigene a,syb_zdifactory b,syb_zdplu c
where a.gno_goods=c.gno_goods and a.no_factory=b.no_factory
and c.sum_shop<>0
山东数据库 新华同帮
select min(tm),min(isbn),sum(kccs),min(dj),'[',min(cbny),']',min(sm),'[!]',min(mc) from t_kcsm,t_bb,t_kcsl where t_kcsm.bb=t_bb.tjbh and t_kcsm.yxbz='0' and kccs>0 group by t_kcsm.id;河北 山西
河北 山西
文章评论(0条评论)
登录后参与讨论