I'm trying to join 2 different tables (Table99 and Table2) to Table1. The first is a straight-forward RIGHT JOIN. The second is a LEFT JOIN, where I'm trying to take Table1 and Left Join to a Table2, and bring back results from Table1 that don't exist in Table2
Example:
FROM Table1 tbl1
RIGHT JOIN Table99 tbl99 ON tbl1.CARD_ID = tbl99.CARD_ID
AND tbl1.DATE_OPEN = tbl99.DATE_OPEN
LEFT JOIN Table2 tbl2 ON tbl1.ACCOUNT_NUMBER = tbl2.ACCOUNT_NUMBER
AND tbl1.APPL_ID = tbl2.APPL_ID'
WHERE tbl1.ACCOUNT_NUMBER <> tbl2.ACCOUNT_NUMBER
The Left Join clause is where I'm trying to pull in all of the results from tble1 that do NOT exist in tbl2