用外连接:
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
转载于:https://www.cnblogs.com/zbl3033/p/3339092.html