sql - How to write query that how much customer A borrowed -

i have following tables account, branch, customer, loan, borrower, depositor..

how can write query how 'customera' borrowed?

i tried writing

select borrower.customer_name, loan.amount borrower, loan borrower.loan_number=loan.loan_number , customer_name = 'customera'; 

its showing no rows selected new querying ..pls help

note, way, implicit joins (having 2 tables in clause) deprecated syntax, , it's recommended switch modern, explicit, syntax:

also if use alias.

select b.customer_name, l.amount  borrower b inner join loan l    on b.loan_number = l.loan_number      b.customer_name = 'customera'; 

as sstan suggest query looks ok. try remove part , see if there data on join result.