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 |