|
Lines 56-61
SELECT
Link Here
|
| 56 |
quantity-quantityreceived AS tleft, |
56 |
quantity-quantityreceived AS tleft, |
| 57 |
ecost, budgetdate, entrydate, |
57 |
ecost, budgetdate, entrydate, |
| 58 |
aqbasket.booksellerid, |
58 |
aqbasket.booksellerid, |
|
|
59 |
aqbooksellers.name as vendorname, |
| 59 |
itype, |
60 |
itype, |
| 60 |
title |
61 |
title |
| 61 |
FROM (aqorders, aqbasket) |
62 |
FROM (aqorders, aqbasket) |
|
Lines 65-70
LEFT JOIN aqorders_items ON
Link Here
|
| 65 |
aqorders.ordernumber=aqorders_items.ordernumber |
66 |
aqorders.ordernumber=aqorders_items.ordernumber |
| 66 |
LEFT JOIN items ON |
67 |
LEFT JOIN items ON |
| 67 |
items.itemnumber=aqorders_items.itemnumber |
68 |
items.itemnumber=aqorders_items.itemnumber |
|
|
69 |
LEFT JOIN aqbooksellers ON |
| 70 |
aqbasket.booksellerid = aqbooksellers.id |
| 68 |
WHERE |
71 |
WHERE |
| 69 |
aqorders.basketno=aqbasket.basketno AND |
72 |
aqorders.basketno=aqbasket.basketno AND |
| 70 |
budget_id=? AND |
73 |
budget_id=? AND |