在两段SQL语句中间加NOT EXISTS语句时，无法查询获得结果

not exists 是不存在则条件成立，执行前面的语句，否则该语句会被跳过

not EXISTS 通俗点讲，就是返回一个boolean类型 。也就是你的这个条件的意思，如果

SELECT
    militarySuperviseQuarterSubmissionTable.fileSubmissionPersonId
FROM
    militarySuperviseQuarterSubmissionTable,
    projectMemberRelationTable
WHERE
    militarySuperviseQuarterSubmissionTable.fileSubmissionPersonId = projectMemberRelationTable.systemUserID
AND projectMemberRelationTable.projectID = 22
AND militarySuperviseQuarterSubmissionTable.militarySuperVisorUniqueId = 2

这里有查询出来没有数据，条件才成立

废话不多说，你想要的结果应该是这样的吧：

    SELECT
    BSPMSuser.userName,
    BSPMSuser.userDepartment,
    projectMemberRelationTable.systemUserID,
    userAuthority.authorityName,
    BSPMSuser.MemberResponsiblity,
    BSPMSuser.memberPosition,
    BSPMSuser.MemberTitle,
    BSPMSuser.memberAddress,
    BSPMSuser.userPhoneNumber,
    BSPMSuser.memberNote
FROM
    BSPMSuser,
    userAuthority,
    militarySuperviseQuarterSubmissionTable,
    projectMemberRelationTable
WHERE
    projectMemberRelationTable.projectID = 22
AND projectMemberRelationTable.authorityId = userAuthority.userGroupID
AND projectMemberRelationTable.systemUserID = BSPMSuser.userID
AND NOT IN (
    SELECT
        militarySuperviseQuarterSubmissionTable.fileSubmissionPersonId
    FROM
        militarySuperviseQuarterSubmissionTable,
        projectMemberRelationTable
    WHERE
        militarySuperviseQuarterSubmissionTable.fileSubmissionPersonId = projectMemberRelationTable.systemUserID
    AND projectMemberRelationTable.projectID = 22
    AND militarySuperviseQuarterSubmissionTable.militarySuperVisorUniqueId = 2
);