Lines 2644-2650
sub GetInvoiceDetails {
Link Here
|
2644 |
my $invoice = $sth->fetchrow_hashref; |
2644 |
my $invoice = $sth->fetchrow_hashref; |
2645 |
|
2645 |
|
2646 |
$query = q{ |
2646 |
$query = q{ |
2647 |
SELECT aqorders.*, biblio.*, biblioitems.*, aqbasket.basketname |
2647 |
SELECT aqorders.*, biblio.*, |
|
|
2648 |
biblio.copyrightdate, |
2649 |
biblioitems.publishercode, |
2650 |
biblioitems.publicationyear, |
2651 |
aqbasket.basketname |
2648 |
FROM aqorders |
2652 |
FROM aqorders |
2649 |
LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno |
2653 |
LEFT JOIN aqbasket ON aqorders.basketno = aqbasket.basketno |
2650 |
LEFT JOIN biblio ON aqorders.biblionumber = biblio.biblionumber |
2654 |
LEFT JOIN biblio ON aqorders.biblionumber = biblio.biblionumber |
2651 |
- |
|
|