The Join Command Continued
If there is a row in one table that does not match any row in the other table, that row will not appear in the result of the join
PROJECT command can be used to restrict the output from the join
Natural join – joins the records from each original table that is common to both tables
Outer join – joins the records from each original table including the records not common to both tables