用外连接: SELECT * from PERempms left outer join PERPROMS
on PERPROMS.BRANCH =PERempms.BRANCH left outer join PEREDUMS
on PEREDUMS.Education_CODE =PERempms.Education left outer join PERGRDMS
on PERGRDMS.GRADE=PEREMPMS.GRADE
用外连接: SELECT * from PERempms left outer join PERPROMS
on PERPROMS.BRANCH =PERempms.BRANCH left outer join PEREDUMS
on PEREDUMS.Education_CODE =PERempms.Education left outer join PERGRDMS
on PERGRDMS.GRADE=PEREMPMS.GRADE