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...