Alias Notation is allowed in Salesforce SOQL.

In the following sample SOQL, I have used Con as alias for Contact object and Acct for the Account object.

Sample SOQL:

SELECT FirstName, LastName 
FROM Contact Con, Con.Account Acct 
WHERE Acct.Name = 'InfallibleTechie'