1 2 3 4 5 6 7 8 9 10 11 12
| SELECT sch.prodstatusid, sch.prodstatusid2, Q.sonbralt, sch.prodid, sch.siteid, sch.deliveryno, sch.floorid, sch.location, SUM(sch.amount) as amount, MAX(sch.schdate), sch.deliverydate, C.shortname, R.c_address, M.descr
FROM Customers C
INNER JOIN roadsheet R ON C.custid = R.custid
INNER JOIN rsscheduledtl sch ON R.roadsheetid = sch.roadsheetid
INNER JOIN QOHdr Q ON sch.qonbr = Q.qonbr
INNER JOIN Municipality M ON Q.municipalityId = M.Municipalityid
WHERE sch.prodid IN (" & critereProd & ")
AND sch.deliverydate = '" & dateLiv & "'
AND Q.sonbralt <>''
AND sch.isactive = 1
AND Q.isActive = 0
GROUP BY sch.prodstatusid, sch.prodstatusid2, Q.sonbralt, sch.prodid, sch.deliveryno, sch.floorid, sch.location, sch.deliverydate, C.shortname, R.c_address, M.descr, sch.siteid |
Partager