Parameter Query

[ICTkirsten]

Hello, I am reading some code for a query..

SELECT Rooms.RoomNum
FROM Rooms LEFT JOIN [Rooms Reserved] ON Rooms.RoomNum=[Rooms Reserved].Room
WHERE ((([Rooms Reserved].Room) Is Null));


can someone tell me what it means..

thank you

 

[CJ_London]

it is finding all the rooms in the table rooms which does not have a reservation

 

[ICTkirsten]

thank you