T-SQL - Aliasing using "=" versus "as"

how to use alias column name in where clause mysql
sql alias without as
sql alias in where clause
sql column alias
sql alias join
how to join two tables with alias
alias in sql example
sql as