Combine Two Tables

we need to combine records from two or more tables , we need to join the tables. There are two common types of join and it is important to understand their differences:

Inner Join - Selects only records from both tables that have matching values. This is also the default join. Outer Join - Does not require each record in the two joined tables to have a matching record. Left Outer Join - Returns all values from the left table, even if there is no match with the right table.

Since the question requires information for each person regardless if there is an address for that person, the answer is to use an outer join.

You may use either a  LEFT JOIN  (Person LEFT JOIN Address) or a  RIGHT JOIN  (Address RIGHT JOIN Person).

 

Ans:

# Write your MySQL query statement below
SELECT Person.FirstName, Person.LastName, Address.City, Address.State FROM Person LEFT JOIN Address ON Person.PersonId=Address.PersonId

[Leetcode|SQL] Combine Two Tables

标签：

查看更多关于Combine Two Tables的详细内容...