help needed
I need a complete patron list with item.barcodes (items still with that
patron). this report should also include the patrons which don't have any item
with them.
what i made isSELECT
borrowernumber,borrowers.cardnumber,borrowers.surname,borrowers.firstname,borrowers.address,borrowers.address2,borrowers.branchcode,borrowers.categorycode,borrowers.dateenrolled,borrowers.dateexpiry,borrowers.debarredcomment,borrowers.borrowernotes,items.barcodeFROM
borrowers
LEFT JOIN items
but there is a syntax error, i don't know where?Monisa Aslam
_______________________________________________
Koha mailing list http://koha-community.org
Koha@lists.katipo.co.nz
https://lists.katipo.co.nz/mailman/listinfo/koha
