|
Lines 39-45
sub search {
Link Here
|
| 39 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
39 |
borrowers.borrowernotes, borrowers.branchcode, borrowers.email, |
| 40 |
borrowers.userid, borrowers.dateofbirth, borrowers.categorycode, |
40 |
borrowers.userid, borrowers.dateofbirth, borrowers.categorycode, |
| 41 |
categories.description AS category_description, categories.category_type, |
41 |
categories.description AS category_description, categories.category_type, |
| 42 |
branches.branchname"; |
42 |
branches.branchname, borrowers.phone"; |
| 43 |
my $from = "FROM borrowers |
43 |
my $from = "FROM borrowers |
| 44 |
LEFT JOIN branches ON borrowers.branchcode = branches.branchcode |
44 |
LEFT JOIN branches ON borrowers.branchcode = branches.branchcode |
| 45 |
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode"; |
45 |
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode"; |