Differnace of two tables for each

Hiyas,

    I am trying to get the differance of two table for each date in the second. I figured out the syntax for one date but how can I get the same thing for each date?

essentially I need to combine this into one query some how:

SELECT *
FROM AIRCRAFT A
WHERE A.SERIAL_NUM NOT IN(

     SELECT S.SERIAL_NUM
     FROM SCHEDULED_FLT S
     WHERE S.FLT_DATE = '12-MAY-02');

SELECT *
FROM AIRCRAFT A
WHERE A.SERIAL_NUM NOT IN(

     SELECT S.SERIAL_NUM
     FROM SCHEDULED_FLT S
     WHERE S.FLT_DATE = '13-MAY-02');

SELECT *
FROM AIRCRAFT A
WHERE A.SERIAL_NUM NOT IN(

     SELECT S.SERIAL_NUM
     FROM SCHEDULED_FLT S
     WHERE S.FLT_DATE = '14-MAY-02');

SELECT *
FROM AIRCRAFT A
WHERE A.SERIAL_NUM NOT IN(

     SELECT S.SERIAL_NUM
     FROM SCHEDULED_FLT S
     WHERE S.FLT_DATE = '15-MAY-02');

Thanx,

    Christopher Received on Sat Jul 20 2002 - 12:25:35 CEST