175. Combine Two Tables
来源:互联网 发布:工业机器人控制算法 编辑:程序博客网 时间:2024/06/03 14:43
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
代码如下:
# Write your MySQL query statement below
select FirstName,LastName,City,State from Person left join Address on Person.PersonId=Address.PersonId
SQL LEFT JOIN 关键字
LEFT JOIN 关键字会从左表 (table_name1) 那里返回所有的行,即使在右表 (table_name2) 中没有匹配的行。
阅读全文
0 0
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- LeetCode : 175. Combine Two Tables
- leetcode 175. Combine Two Tables
- leetcode.175. Combine Two Tables
- leetcode 175. Combine Two Tables
- Leetcode 175. Combine Two Tables
- leetcode 175. Combine Two Tables
- 【LeetCode】175. Combine Two Tables
- [LeetCode] 175. Combine Two Tables
- JZOJ 5401. 【NOIP2017提高A组模拟10.8】Star Way To Heaven
- git pull和git push的区别
- centos7使用yum安装mariaDB(开源MySQL)无法启动的解决办法
- (一)异常处理
- [BZOJ]1206: [HNOI2005]虚拟内存 线段树
- 175. Combine Two Tables
- 织梦留言板添加验证码
- 【LeetCode】C# 17、Letter Combinations of a Phone Number
- colorPrimary、colorPrimaryDark、colorAccent
- 运行LINE
- 这里没有key
- PS-day9-个人学习笔记
- BMP格式知识之二:16位,24位,32位的BMP图片算法是如何运算的
- SQL Server CLR系列(3)-发送POST请求