本文共 877 字,大约阅读时间需要 2 分钟。
题目:
Table: Person
+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |+-------------+---------+PersonId is the primary key column for this table.
Table: Address
+-------------+---------+| Column Name | Type |+-------------+---------+| AddressId | int || PersonId | int || City | varchar || State | varchar |+-------------+---------+AddressId is the primary key column for this table.
Write a SQL query for a report that provides the following information for each person in the Person table, regardless if there is an address for each of those people:
FirstName, LastName, City, State
解释:数据库左外链接
SQL语句:
# Write your MySQL query statement belowselect FirstName, LastName, City, State from Person left join Address on Person.PersonId =Address.PersonId;
转载地址:http://bkhci.baihongyu.com/