SQL server四种连接
基本解释
– left join (左连接):返回包括左表中的所有记录和右表中连接字段相等的记录。
– right join (右连接):返回包括右表中的所有记录和左表中连接字段相等的记录。
– inner join (等值连接或者叫内连接):只返回两个表中连接字段相等的行。
– full join (全外连接):返回左右表中所有的记录和左右表中连接字段相等的记录。
--内连接
select * from [hongd39.PD_UE] u inner join [hongd39.PD_Equipment] e on u.EquipmenID =e.EquipmenID where e.ESn='1234567887654320'
--左连接
select* from [hongd39.PD_Equipment] e left join [hongd39.PD_UE] u on u.EquipmenID =e.EquipmenID where e.ESn='1234567887654320'
--右连接
select* from [hongd39.PD_Equipment] e right join [hongd39.PD_UE] u on u.EquipmenID =e.EquipmenID where e.ESn='1234567887654320'
--右外连接
select* from [hongd39.PD_Equipment] e left outer join [hongd39.PD_UE] u on u.EquipmenID =e.EquipmenID where e.ESn='1234567887654320'
--左外连接
select* from [hongd39.PD_Equipment] e left outer join [hongd39.PD_UE] u on u.EquipmenID =e.EquipmenID where e.ESn='1234567887654320'