SELECT borrowers.*,
category_type,
categories.description,
enrolmentperiod
FROM borrowers
LEFT JOIN categories ON borrowers.categorycode=categories.categorycode
WHERE borrowernumber = ?
LEFT JOIN categories ON borrowers.categorycode = categories.categorycode
WHERE cardnumber = ?
-