Re: SQL Unmatched records Question

Charcoal <who_at_cares.com> wrote in message news:_mcL6.264$V5.1159_at_news1.rivrw1.nsw.optushome.com.au...
> Hi again,
>
> I have two tables in an Oracle database and I want to display all the
> records in one table which are NOT in the other table. Let me explain
 using
> the schema below:
>
> Seats(SeatID) which ranges from 1 to 10. {1, 2, 3, 4, 5, 6, 7, 8, 9, 10}
> SoldSeats(FlightID, SeatID) which defines which seats have been sold for a
> particular flight.
>
> So for example, if seats 1,2,3 have been sold for FlightID 100 then I
 would
> want it to return
>
> 100 4
> 100 5
> 100 6
> 100 7
> 100 8
> 100 9
> 100 10
>
> But if a seat has been sold in another Flight, then it shouldnt affect
> Flight 100's results. So what is the SQL Query to do something like this?
>

I would say

SELECT Seats.SeatID, SoldSeats.FlightID
FROM Seats, SoldSeats
WHERE SoldSeats.FlightID = 100

MINUS SELECT SeatID, FlightID
FROM SoldSeats
WHERE FlightID = 100 Received on Sun May 13 2001 - 01:55:11 CEST