Syntax Rules

The table name is used when more than one column is being referenced
The table name is used when a column is being used outside the table

Specal Characters
An extra pair of square brackets is added when a column name contains any of these characters

Escape Characters
An apostrophe is added at the front when a column name contains any of these characters