【SQL打卡】组合两个表

Question

SELECT p.FirstName,p.LastName,a.City,a.State 

FROM Person p  left join  Address  a   

WHERE  p.PersonId= a.AddressId

Answer 1

联表查询怎么能用where呢，是on啊