Table Aliases and Multi-Table Joins | Essential SQL скачать в хорошем качестве

Table Aliases and Multi-Table Joins | Essential SQL

Joins have got you confused. Then let’s get that fixed! Check out Join Together Now! https://www.udemy.com/course/join-tog... You'll find that as you write more complicated joins, that the SQL can become harder to read, as you'll need to qualify column with table names to avoid ambiguity. To make you SQL more compact and more readable you can create table aliases.  The aliases become a short-hand naming convention. That way, instead of referring to Person.PersonPhone.BusinessEntityID we can create the alias PP for Person.PersonPhone and simply refer to the column as PP.BusinessEntityID. I like table aliases because: 1. It makes the SQL easier to read 2. I’m less apt to make a mistake typing 3. They help me avoid ambiguous column names