1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
| SELECT sch.prodstatusid, sch.prodstatusid2, q.sonbralt, p.Name, s.sitecode, sch.deliveryno, sch.floorid, sch.location, sch.amount, sch.schdate, sch.deliverydate, c.shortname, r.c_address, m.descr, sch.rsschdtlid, schwc.nbhours, r.littletruckbit, r.includedcrane, r.noincludedcrane, r.rolloff, r.zone2, r.normaldelivery, r.steeldelivery, r.escort, r.restrictedaccess, r.elsewhereprov, sch.stocksiteid
FROM rsscheduledtl sch
INNER JOIN rsscheduledtlwc schwc ON sch.rsschdtlid = schwc.rsschdtlid
INNER JOIN workcenter w ON schwc.wcid = w.wcid
INNER JOIN Sites s ON sch.siteid = s.siteid
INNER JOIN Products p ON sch.prodid = p.prodid
LEFT JOIN floorhdr f ON sch.floorid = f.floorid
INNER JOIN roadsheet r on sch.roadsheetid = r.roadsheetid
INNER JOIN QOHdr q ON r.qonbr = q.qonbr
INNER JOIN Municipality m ON q.municipalityid = m.municipalityid
INNER JOIN Customers c ON q.custid = c.custid
WHERE sch.prodstatusid IN (" & IdStatus & ")
AND sch.deliverydate = '" & dateliv & "'
AND sch.isactive = 1
AND schwc.wcid = 1 |
Partager