SQLServer 连表查询

—————————— 使用inner join.. on… 链接表查询—————–
select * from StuInfo inner join StuMarks
on StuInfo.StuID=StuMarks.StuID
—跟普通的where 方法一样

select * from StuInfo,StuMarks where StuInfo.StuID=StuMarks.StuID

select * from user_info s1 left outer join user_score s2 on s1.uid=s2.uid
select * from user_info s1 inner join user_score s2 on s1.uid=s2.uid

————–union 和union all 并集运算
select * StuMark where Score >=90
union
select * StuMark where StuId=3

—————–使用intersect 进行交集运算
select * StuMark where Score >=90
intersect
select * StuMark where StuId=3

—————–使用 except 进行减集运算
select * StuMark where Score >=90
except
select * StuMark where StuId=3