Comparative solution between LEFT JOIN, LEFT JOIN USING and NATURAL LEFT JOIN
basic left join: 902ms.\n\n    SELECT FirstName, LastName, City, State\n    FROM Person\n    LEFT JOIN Address\n    ON Person.PersonId = Address.PersonId;\n\nle
basic left join: 902ms.\n\n    SELECT FirstName, LastName, City, State\n    FROM Person\n    LEFT JOIN Address\n    ON Person.PersonId = Address.PersonId;\n\nleft join + using: 907ms\n\n    SELECT FirstName, LastName, City, State\n    FROM Person\n    LEFT JOIN Address\n    USING(PersonId);\n\nnatural left join: 940ms\n\n    SELECT FirstName, LastName, City, State\n    FROM Person\n    NATURAL LEFT JOIN Address;\n\nleft join is the fastest compare to the two others.
['MySQL']