详细题目描述见Leetcode175题
主要是考察连接中所谓内连接与外连接的差别:
select firstName,lastName,city,state
from person left join address
on person.personid = address.personid;
详细题目描述见Leetcode175题
主要是考察连接中所谓内连接与外连接的差别:
select firstName,lastName,city,state
from person left join address
on person.personid = address.personid;