SELECT a.prodID,d.prodName,
SUM(Iif(b.opername = 'realiz' AND b.operdate <#09/01/2016#, ((SELECT TOP 1 z.prodprice FROM   products z WHERE  a.prodid = z.prodid  AND  z.pricedate <=# 09 / 01 / 2016# ORDER  BY z.pricedate DESC)*b.quantity), 0)) AS Realiz
      
FROM   (((
(select prodID from remains WHERE salID=19
UNION
SELECT DISTINCT a.prodID FROM operations a, users b, crossbase c, products d WHERE  c.useFlag=1 AND c.salID=19 AND b.salID = c.salID AND c.basID=d.basID AND d.prodID=a.prodID) AS a
           LEFT JOIN operations AS b ON a.prodid = b.prodid)
          LEFT JOIN remains AS c ON a.prodid = c.prodid)
         LEFT JOIN products AS d ON a.prodid = d.prodid)
GROUP BY a.prodID,d.prodName
ORDER  BY d.prodname; 

	var RS = MDB.OpenRecordset(	"SELECT \
						a.prodID, \ 
						d.prodName, \
						d.prodUnit, \
						(SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=#"+sqlBeginDate+"# ORDER BY z.priceDate DESC) AS prodPrice,\
						c.Quantity AS RNP, \
						ROUND((SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=#"+sqlBeginDate+"# ORDER BY z.priceDate DESC)*c.Quantity,2) AS RNPAmnt, \
						SUM(IIF(b.operName='realiz' AND b.operDate<#"+sqlBeginDate+"#, ((SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=#"+sqlBeginDate+"# ORDER BY z.priceDate DESC)*b.Quantity), 0)) AS Realiz, \
						SUM(IIF(b.operName='realiz' AND b.operDate BETWEEN #"+sqlBeginDate+"# AND #"+sqlEndDate+"#, ((SELECT TOP 1 z.prodPrice FROM products z WHERE a.prodID=z.prodID AND z.priceDate<=b.operDate ORDER BY z.priceDate DESC)*b.Quantity), 0)) AS PRealiz \
					FROM ((( \
						(SELECT prodID from remains WHERE salID=19 \
						UNION \
						SELECT DISTINCT a.prodID FROM operations a, users b, crossbase c, products d WHERE c.useFlag=1 AND c.salID=19 AND b.salID=c.salID AND c.basID=d.basID AND d.prodID=a.prodID) AS a \
						LEFT JOIN operations AS b ON a.prodid = b.prodid) \
						LEFT JOIN remains AS c ON a.prodid = c.prodid) \
						LEFT JOIN products AS d ON a.prodid = d.prodid) \
					GROUP BY \
						a.prodID, \
						d.prodName, \
						d.prodUnit, \
						c.Quantity \
					ORDER BY \
						d.prodname;");