2023.11.15
175.组合两个表
https://leetcode.cn/problems/combine-two-tables/description/
- 代码：
select p.firstName,p.lastName,a.city,a.state
from Person p
left join Address a on a.personId=p.personId
https://leetcode.cn/problems/combine-two-tables/description/
select p.firstName,p.lastName,a.city,a.state
from Person p
left join Address a on a.personId=p.personId