Why this uses two different aliases for the same table?

[harishgg1]

One Scenario .. name is not an exact match

please google search for SQL Data Anamolies