SQL Query: looking for null -

SQL Query: looking for null -

the question is: want first book , pick seats flight. find flight_num , date of flights there no reservations.

from next tables:

flights (flight_num, source_city, dest_city) departures (flight_num, date, plane_type) passengers (passenger_id, passenger_name, passenger_address) bookings (passenger_id, flight_num, date, seat_number)

my reply was:

select d.flight_num, d.date departures d, bookings b b.passenger_id = null

i know wrong, can tell me why? reply this?

this might better:

select d.flight_num, d.date departures d bring together bookings b on d.flight_num = b.flight_num b.passenger_id null

i'm not sure if possible book, not reserve seat number. if is, need alter clause that.

sql