- as ordnum,entrydate,budgetdate,aqbasket.booksellerid,aqbasket.basketno
- from aqorders
- inner join aqorderbreakdown on aqorderbreakdown.ordernumber = aqorders.ordernumber
- inner join aqbasket on aqbasket.basketno = aqorders.basketno
- left join items on items.biblionumber=aqorders.biblionumber
- where bookfundid=?
- and (datereceived >= ? and datereceived < ?)
+ as ordnum,entrydate,budgetdate,booksellerid,aqbasket.basketno
+ from aqorderbreakdown,aqbasket,aqorders
+ left join biblioitems on biblioitems.biblioitemnumber=aqorders.biblioitemnumber
+ where bookfundid=? and
+ aqorders.ordernumber=aqorderbreakdown.ordernumber and
+ aqorders.basketno=aqbasket.basketno
+ and (
+ (datereceived >= ? and datereceived < ?))