mysql 组合两张表
程序员文章站
2022-05-03 22:24:11
select P.FirstName,P.Lastname,A.City,A.State from Person P left join Address A on P.PersonId = A.PersonId; ......
select p.firstname,p.lastname,a.city,a.state from person p left join address a on p.personid = a.personid;