ADOQuery1.sql.add('select SPJG from JH inner join SPZL on SPZL.ID=JH.ID where SPZL.SPID like '+''+'%D%'+''); i:=ADOQuery1.RecordCount; 大概就是这样,你的表我不太清楚.希望给你些提示.
----------------------------------------------
-
大家给我看看这句错在哪儿: sql.text:='select e. SPID,(a.SPNUM+b.SPNUM-c.SPNUM-d.SPNUM) as 库存数量 from (select spid,sum(spnum) as spnum from QCKC group by spid ) a,(select spid,sum(spnum) as spnum from jh group by spid ) b, (select spid,sum(spnum) as spnum from th group by spid ) c, (select spid,sum(spnum) as spnum from ls group by spid )d,spzl e+ where e.spid=a.spid and e.spid=b.spid and e.spid=c.spid and e.spid=d.spid and e.spid like '+#39+'%'+trim(edit1.text)+'%'+#39;
----------------------------------------------
-