Desired Output

A list of only the repayments that have matched borrower names available

Query

select t$1.*,$ t$2.$borrower$\_$name from bank$\_$data.repayments t$1$

join bank$\_$data.identities t$2$

on $11.$borrower$\_$id $=$ t$2.$borrower$\_$id;

$12.$ Desired Output

A list of all repayments with matched borrower names if available, or a blank value in the borrov

Query

select t$1.$borrower$\_$name, t$2.*$ from bank$\_$data.identities $t1$

join bank$\_$data.repayments t$2$

on t$1.$borrower$\_$id $=$ t$2.$borrower$\_$id;