i couldn't figure out why i kept getting the 'multi-part identifier' error until i read page 87 where it says 'using an alias is an all-or-nothing proposition. Once you decide to alias a table, you must use that alias in every part of the query'.
so i started using the alias everywhere in the query and i quit getting that error.
but.. why does this query work?
select pp.FirstName, LastName
from Person.Person pp
i'm not being consistent with the 'pp' alias.. so i must not understand fully the rule on when an alias is 'required'...
can this be explained a little further?