Does this help?  Just a small sample of the tables.

Loan Table:
ProcessDate-------------ParentAccount-----------CloseDate-------------ChargeOffDate----------------OriginalBalance---------------Type
20180208-------------------0000012430-------------NULL--------------------NULL------------------------------NULL---------------------------77
20180208-------------------0000017770-------------NULL--------------------NULL------------------------------NULL---------------------------77
20180208-------------------0000017770-------------NULL--------------------NULL------------------------------500-----------------------------77

Savings Table:
ProcessDate------------ParentAccount-------------ShareCode-------------CloseDate
20180208-----------------0000012430---------------------1------------------------NULL
20180208-----------------0000017770---------------------1------------------------NULL
20180208-----------------0000017770---------------------1------------------------NULL

Account Table:
ProcessDate--------------AccountNumber------------CloseDate
20180208--------------------0000012430------------------NULL
20180208--------------------0000017770------------------NULL

Perfect!  Thanks for the help!

Thank you, maybe I'm not explaining my issue clearly.
I want to get all of the Accounts, regardless of whether they have a 1 or 2 in the ShareType column,...