Pilot Query

[Untamed92]

I have this access project where I have two queries of pilots 105 and 109. I am supposed to create a query using these that shows all of their airline trips except the ones where they are TOGETHER.

My SQL for Query 1
SELECT CHARTER.CHAR_TRIP, CHARTER.CHAR_PILOT, CHARTER.CHAR_COPILOT
FROM CHARTER
WHERE (((CHARTER.CHAR_PILOT) In (105,109))) OR (((CHARTER.CHAR_COPILOT) In (105,109)));

My SQL for Query 2
SELECT CHARTER.CHAR_TRIP, CHARTER.CHAR_PILOT, CHARTER.CHAR_COPILOT
FROM CHARTER
WHERE (((CHARTER.CHAR_PILOT) In (105,109)) AND ((CHARTER.CHAR_COPILOT) In (105,109)));

I must exclude the one with the AND statement from the one with the OR somehow. Any help is appreciated.

 

[ByteMyzer]

Why not just use:

SELECT CHARTER.CHAR_TRIP, CHARTER.CHAR_PILOT, CHARTER.CHAR_COPILOT
FROM CHARTER
WHERE (CHARTER.CHAR_PILOT   In (105,109) OR
       CHARTER.CHAR_COPILOT In (105,109))
AND CHARTER.CHAR_PILOT <> CHARTER.CHAR_COPILOT;