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, but I don't want duplicates of the Accounts.  
If the Account has a 1 and a 2 in the ShareType, I just want to see yes, but if the Account has a 2 and a 3 in the ShareType, I just want to see that it doesn't have a 1, but I still want to see the Account Number.
Does that make sense?