SELECT discharges.discharge_id, discharges.borrower, borrowers.borrowernumber, borrowers.cardnumber, borrowers.surname, borrowers.firstname, borrowers.address, borrowers.email
FROM discharges
LEFT JOIN borrowers
on discharges.borrower = borrowers.borrowernumber
Thanks
DP Tripathi