SQL query return records even when criteria in one table is not satisfied
I have two tables.
LN_CODES which has the loan number LNKEY
LN_FEES which is a list of loan fees FEENAME, BORRPART
I want to show the loan number, and the flood fee. If there is no flood fee I still want to show the loan number, and show either $0 or null as the flood fee. Here is my current query. Any help would be appreciated!
SELECT EMPOWER.U_LN_CODES.LNKEY, EMPOWER.LN_FEES.FEENAME, EMPOWER.LN_FEES.BORRPART
FROM EMPOWER.U_LN_CODES LEFT OUTER JOIN
EMPOWER.LN_FEES ON EMPOWER.U_LN_CODES.LNKEY = EMPOWER.LN_FEES.LNKEY
WHERE (EMPOWER.U_LN_CODES.LNKEY = '2011-1784433') AND (EMPOWER.LN_FEES.FEENAME = 'Flood')