175. Combine Two Tables
Solution Code
MySQL
SELECTPerson.FirstName,Person.LastName,Address.City,Address.StateFROMPersonLEFTJOINAddressONPerson.PersonId=Address.PersonId;SELECTPerson.FirstName,Person.LastName,Address.City,Address.StateFROMPersonLEFTJOINAddressONPerson.PersonId=Address.PersonId;