Combine Two Tables
来源:互联网 发布:tencent是什么软件 编辑:程序博客网 时间:2024/06/06 16:50
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
题意:合并Person,Address两张表
select Person.FirstName, Person.LastName, Address.City, Address.State from Person left join Address on Person.PersonId = Address.PersonId;
0 0
- 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
- 175 - Combine Two Tables
- Combine Two Tables
- 【Leetcode】Combine Two Tables
- 175. Combine Two Tables
- 175. Combine Two Tables
- Combine Two Tables
- 苹果为啥要在iOS 9中使用新字体?
- adb devices offline方法总结
- Android的minSdkVersion,targetSdkVersion,maxSdkVersion
- Ubuntu下phpStorm7中文linux版安装
- hashCode、equals、==三者的区别与联系
- Combine Two Tables
- Unity动态加载远程资源
- 感知器,线性回归,logistic回归
- emacs-minor笔记
- Linux在本地建立git仓库管理代码
- 【JavaScript 1—基础知识点】:宏观概述
- 有限自动状态机
- onethink中有言评论系统后台配置UID无效的解决办法
- 面试官问现在工资是多少该怎么回答?