|
Lines 66-73
sub GetBooksellersWithLateOrders {
Link Here
|
| 66 |
FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno |
66 |
FROM aqorders LEFT JOIN aqbasket ON aqorders.basketno=aqbasket.basketno |
| 67 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
67 |
LEFT JOIN aqbooksellers ON aqbasket.booksellerid = aqbooksellers.id |
| 68 |
WHERE |
68 |
WHERE |
| 69 |
( datereceived = '' |
69 |
( datereceived IS NULL |
| 70 |
OR datereceived IS NULL |
|
|
| 71 |
OR aqorders.quantityreceived < aqorders.quantity |
70 |
OR aqorders.quantityreceived < aqorders.quantity |
| 72 |
) |
71 |
) |
| 73 |
AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0 |
72 |
AND aqorders.quantity - COALESCE(aqorders.quantityreceived,0) <> 0 |
| 74 |
- |
|
|