郑维勇的博客

    1、左外联接(left outer join)

    Eg:

    Select a.部门编号,a.部门名称,a.负责人,b.人员编号,b.人员姓名,b.部门名称,b.学历,b.技术职称  from tb_nMRde09 a left outer join tb_mMRem09 b   on a.部门名称=b.部门名称

    2、右外联接(right outer join)

    Eg:

    Select * from tb_nMRde09 a right outer join tb_nMRpay09 b

    on a.部门名称=b.部门名称  where b.工资月份='10'

   3、完全联接(full join)

    Eg:

    Select * from tb_student09 a full join tb_course09 b on a.自动编号=b.编号