175 - Combine Two Tables
来源:互联网 发布:mac中如何将文件隐藏 编辑:程序博客网 时间:2024/06/06 02:02
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
Subscribe to see which companies asked this question
思路分析:
left join
SELECT Person.FirstName, Person.LastName, Address.City, Address.StateFROM Person LEFT JOIN Address ON Person.PersonId = Address.PersonId;
0 0
- 175 - Combine Two Tables
- LeetCode 175 -Combine Two Tables ( MYSQL )
- leetCode Databases 175 Combine Two Tables
- Combine Two Tables Leetcode
- Combine Two Tables
- Combine Two Tables
- Combine Two Tables
- Combine Two Tables
- Combine Two Tables
- Leetcode: Combine Two Tables
- Combine Two Tables
- [LeetCode]Combine Two Tables
- LeetCode Combine Two Tables
- Combine Two Tables
- 175. Combine Two Tables
- Combine Two Tables
- 【Leetcode】Combine Two Tables
- 175. Combine Two Tables
- Cocos2d-x像素级触摸处理
- 常用的正则表达式
- iOS-获取当前时间的年、月、日、时、分、秒
- Android 生成keystore,两种方式
- 浅析Apache重写规则中RewriteCond规则参数和 RewriteRule 规则参数
- 175 - Combine Two Tables
- UIPasteboard 粘贴板
- (4.5.1.3)Import project(Eclipse ADT, Gradle, etc.)
- java设计模式——行为型之命令模式
- iOS Core Graphics 和 Core Animation
- mysql 的行转列
- Ubuntu中文语言包的安装
- iOS根据2个经纬度计算距离
- sunjce iOS des 3des解密加密