17 Mar
2016
17 Mar
'16
8:08 a.m.
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