连接

左连接

  1. select *
  2. from Person left join Address
  3. on Person.PersonId = Address.PersonId;

右连接

  1. select *
  2. from Person right join Address
  3. on Person.PersonId = Address.PersonId;

内连接

  1. select *
  2. from Person inner join Address
  3. on Person.PersonId = Address.PersonId;