[Database]Leetcode 175 Combine Two Tables
2021-02-15 10:23 作者:您是打尖兒還是住店呢 | 我要投稿
table:person
<pre>
</pre>
address:
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:
select firstname,lastname,city,state
from person
left join address
on person.personid=address.personid
標(biāo)簽：
