22,210
社区成员
发帖
与我相关
我的任务
分享就没有一个牛人吗????????????????????
查询出下列所有表的字段，5张表连表查询出匹配与不匹配的数据
不匹配时显示主表数据，从表全部显示为NULL，（内联与左外联都试过了显示了太多的重复数据）
UserTable userID,....
JobTable userID,....
OrganTable userid,....
SapTable userID,....
select a.FUserID,a.FChinaName,a.FNameSpell,a.FEnglishName,a.FTitleID,a.FTitleName,a.FSexID,a.FSexName,a.FAge,a.FBirthdayForInternational,a.FBirthdayForChina
,a.FBirthPlace,a.FBirthProvinceID,a.FBirthProviceName,a.FBirthCountryID,a.FBirthCountryName,a.FNationalityID,a.FNationalityName,a.FNationID,a.FNationName
,a.FCertificateNO,a.FCertificateTypeID,a.FMaritalStatusID,a.FMaritalStatusName,a.FMaritalStartDate,a.FReligionID,a.FChildrenAmount,a.FOperationTypeID
,a.FPayrollID,a.FDirectLine,a.FExt,a.FLocationName,a.FSeat,a.FEmployeeType
,b.FUserID,b.FEmail,b.FPostID,b.FPostName,b.FHigherUpID,b.FHigherUpName,b.FArea,b.FAdministrativeDuties,b.FJobClusterID,b.FJobClusterName
,b.FOneLevelCategoryID,b.FOneLevelCategoryName,b.FTwoLevelCategoryID,b.FTwoLevelCategoryName,b.FJobLevelID,b.FJobLevelName,b.FJobRankID,b.FJobRankName
,c.FUserID,c.FAdministrationJobDescription,c.FUserGroupName,c.FUserChildGroupName,c.FProductLine,c.FOperationPost,c.FPersonnelArea,c.FPersonnelAreaText
,e.FUserID,e.FEmployeeID,e.FUserNamePinyin,e.FEnLastName,e.FEnFirstName,e.FTelphone,e.FLocalShortNum,e.FMobileNum,e.FVOIPNum,e.FFax,e.FDepartment,e.FEnDepartment,e.FOfficeLocation
,e.FEnOfficeLocation,e.FOfficeSeat,e.FEnOfficeSeat,e.FDuty,e.FEnDuty,e.FDescription,e.FEnDescription,e.FAuditStatus,e.FIsSapEmployee,e.FBelongSystem
from TB_UUM_User a,
TB_UUM_JobPeople b,
TB_UUM_OrganizationDistribution c,
TB_BP_SapEmployee e
where a.FUserID=b.FUserID and a.FUserID=c.FUserID and a.FUserID=e.FUserID
不匹配时显示主表数据，从表全部显示为NULL，（内联与左外联都试过了显示了太多的重复数据）
UserTable userID,....
JobTable userID,....
OrganTable userid,....
SapTable userID,....
select a.FUserID,a.FChinaName,a.FNameSpell,a.FEnglishName,a.FTitleID,a.FTitleName,a.FSexID,a.FSexName,a.FAge,a.FBirthdayForInternational,a.FBirthdayForChina
,a.FBirthPlace,a.FBirthProvinceID,a.FBirthProviceName,a.FBirthCountryID,a.FBirthCountryName,a.FNationalityID,a.FNationalityName,a.FNationID,a.FNationName
,a.FCertificateNO,a.FCertificateTypeID,a.FMaritalStatusID,a.FMaritalStatusName,a.FMaritalStartDate,a.FReligionID,a.FChildrenAmount,a.FOperationTypeID
,a.FPayrollID,a.FDirectLine,a.FExt,a.FLocationName,a.FSeat,a.FEmployeeType
,b.FUserID,b.FEmail,b.FPostID,b.FPostName,b.FHigherUpID,b.FHigherUpName,b.FArea,b.FAdministrativeDuties,b.FJobClusterID,b.FJobClusterName
,b.FOneLevelCategoryID,b.FOneLevelCategoryName,b.FTwoLevelCategoryID,b.FTwoLevelCategoryName,b.FJobLevelID,b.FJobLevelName,b.FJobRankID,b.FJobRankName
,c.FUserID,c.FAdministrationJobDescription,c.FUserGroupName,c.FUserChildGroupName,c.FProductLine,c.FOperationPost,c.FPersonnelArea,c.FPersonnelAreaText
,e.FUserID,e.FEmployeeID,e.FUserNamePinyin,e.FEnLastName,e.FEnFirstName,e.FTelphone,e.FLocalShortNum,e.FMobileNum,e.FVOIPNum,e.FFax,e.FDepartment,e.FEnDepartment,e.FOfficeLocation
,e.FEnOfficeLocation,e.FOfficeSeat,e.FEnOfficeSeat,e.FDuty,e.FEnDuty,e.FDescription,e.FEnDescription,e.FAuditStatus,e.FIsSapEmployee,e.FBelongSystem
from TB_UUM_User a,
TB_UUM_JobPeople b,
TB_UUM_OrganizationDistribution c,
TB_BP_SapEmployee e
where a.FUserID=b.FUserID and a.FUserID=c.FUserID and a.FUserID=e.FUserID
...全文
请发表友善的回复…
发表回复
fanzhouqi 2012-03-06
- 打赏
- 举报
nnd，谁想看啊，怎么长的代码
开着拖拉机泡妞 2012-03-06
- 打赏
- 举报
楼主舍不得贴出数据来，看了也没好大用
chuanzhang5687 2012-03-06
- 打赏
- 举报
楼主可以自己检查一下，从重复数据中抽出一两条，看一下为什么重复，怎么写才能不重复
YuLongJiuTian 2012-03-06
- 打赏
- 举报
结果是 不管匹配条件成立与否 我都要要显示出数据
叶子 2012-03-06
- 打赏
- 举报
和数据有关系，不知道你是什么样的数据，想要什么样的结果？
zxdii 2012-03-06
- 打赏
- 举报
[Quote=引用 1 楼 szstephenzhou 的回复:]
有重复数据关联的时候一般都是一对多的情况
[/Quote]
+1
有重复数据关联的时候一般都是一对多的情况
[/Quote]
+1
勿勿 2012-03-06
- 打赏
- 举报
有重复数据关联的时候一般都是一对多的情况
