SQl 的左，右，内，全连接

select * from Student
select * from ClassForm

select [Name],ClassName from Student as a left join ClassForm as b on  a.ClassID=b.ID

select [Name],ClassName from Student as a right join ClassForm as b on  a.ClassID=b.ID

select [Name],ClassName from Student as a inner join ClassForm as b on  a.ClassID=b.ID

select [Name],ClassName from Student as a full join ClassForm as b on  a.ClassID=b.ID

 

 

 

posted @ 2012-02-24 11:12  浅谈生活  阅读(177)  评论(0)  编辑  收藏  举报