Try this

SELECT *

FROM TableA a

LEFT OUTER JOIN TableB b ON a.LoanID = b.LoanID

WHERE b.ColumnA <> 'Y'

When we use INNER JOIN it will consider only commom records. But the user wants to consider all records in first table