Скрипт... : Супермаг Плюс (Супермаг 2000)

SELECT
 i.Article,
 a.Name,
 i.Quantity,
 i.TotalSum,
 c.PrintTime,
 c.CheckNum,
 c.ZNum,
 c.DeskNum
FROM
 Supermag.SMCashCheckItems i,
 Supermag.SMCashChecks c,
 Supermag.SMCard a
WHERE
 c.PrintTime BETWEEN TO_DATE('07.09.2009 22:00:00','DD.MM.YYYY HH24:MI:SS') AND TO_DATE('08.09.2009 09:00:00','DD.MM.YYYY HH24:MI:SS')
AND
 i.CheckNum=c.CheckNum
AND
 i.ZNum=c.ZNum
AND
 i.DeskNum=c.DeskNum
AND
 a.Article=i.Article

SELECT   i.article, a.NAME,
         SUM (DECODE (c.opcode, 3, -i.quantity, i.quantity)) AS qty,
         SUM (DECODE (c.opcode, 3, -i.totalsum, i.totalsum)) AS SUM
-- c.PrintTime,
-- c.CheckNum,
-- c.ZNum,
-- c.DeskNum
FROM     supermag.smcashcheckitems i,
         supermag.smcashchecks c,
         (SELECT sc.article, sc.NAME
            FROM supermag.smcard sc, supermag.sacardclass scc
           WHERE sc.idclass = scc.ID AND scc.tree LIKE '1.4.%') a
   WHERE c.printtime BETWEEN TO_DATE ('07.09.2009 22:00:00',
                                      'DD.MM.YYYY HH24:MI:SS'
                                     )
                         AND TO_DATE ('08.09.2009 09:00:00',
                                      'DD.MM.YYYY HH24:MI:SS'
                                     )
     AND i.locid = c.locid
     AND i.checknum = c.checknum
     AND i.znum = c.znum
     AND i.desknum = c.desknum
     AND a.article = i.article
GROUP BY i.article, a.NAME