SQL Server 2005中的外联结用法

use stu_course
select L.sno,sname,ssex,sage,sdept,o,grade
from student L,sc
where L.sno=sc.sno()

use stu_course
select L.sno,sname,ssex,sage,sdept,o,grade
from student L left join sc
on L.sno=sc.sno

use stu_course
select L.sno,sname,ssex,sage,sdept,o,grade
from student L left join sc
on L.sno=sc.sno
where L.sno in(95001,95002,95003,95004)

use stu_course
select L.sno,sname,ssex,sage,sdept,o,grade
from student L left join sc
on L.sno=sc.sno

use stu_course
select sno,course.o,course.ame
from sc right join course
on sc.o=course.o

use stu_course
select sno,course.o,course.ame
from sc full join course
on sc.o=course.o

use stu_course
select sno,course.o,course.ame
from course full join sc
on sc.o=course.o