JOIN ON or JOIN USING (AND A FULL OUTER JOIN)

It is not unusual for the columns you are using to join 2 tables to have the exact same name, if they do you can use the USING clause instead of the ON Clause to simplify the Statement

Here is the SQL

I Joined on a non-Key Field that just happened to be unique and got good results

We are ready to start Terraforming