Форум

Sel ect
      ml.marka as postav,
      ml.grup as sgrup,
      ml.nnum as snnum,
      ml.name as sartic,
      ml.ed as ed,
      mdm.skolout as rskolout,
      mdm.ssum as rssum,
      mdm.ssumout as rssumout

fr om sclad_mlabel ml

join (sel ect
      md.grup,
      md.nnum,
      SUM(IIF(md.vid ='1' and md.type ='5',-md.kolout,(IIF(md.vid ='2' and md.type ='1',md.kolout,0)))) as skolout,
      SUM(IIF(md.vid ='1' and md.type ='5',-md.sum,(IIF(md.vid ='2' and md.type ='1',md.sum,0)))) as ssum,
      SUM(IIF(md.vid ='1' and md.type ='5',-md.sumout,(IIF(md.vid ='2' and md.type ='1',md.sumout,0)))) as ssumout
      fr om sclad_mdocm md
      where (md.date between :Sdate and :edate) and md.schet_a like'361%%' and md.sclad=:sclad and md.sclad<>'000010' and md.sclad<>'000021' and md.sclad<>'000022' and md.sclad<>'000023'
      group by md.grup,md.nnum) mdm on ml.grup = mdm.grup and ml.nnum=mdm.nnum

group by ml.marka,ml.grup,ml.nnum,ml.name,ml.ed,mdm.skolout,mdm.ssum,mdm.ssumout