[Koha] koha reports

[Monisa Aslam]

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