Speaking of keyboard strokes, there is one thing that may come in handy and help you write less: a table alias.
Imagine the following situation: we want to select many columns from two joined tables. These tables may share some column names, so best practices tell us to precede the column names with the table name and a dot. You could, of course, write it like this:
INNER JOIN Car
ON Person.ID = Car.OwnerID;
But that takes a lot of writing, doesn't it? Fortunately, there is a way to make things simpler: we can introduce new temporary names (aliases) for our tables:
FROM Person AS P
INNER JOIN Car AS C
ON P.ID = C.OwnerID;
As you can see, we introduced the
AS keyword after the table names in the
FROM clause. Just as with column aliases,
AS indicates that whatever came before it should be given the new, temporary name (alias) that follows. With
AS, we can save our fingers a lot of typing and write shorter names for our tables.