One more question

I need to add a join to this table to get information about the room, such as the description and RoomAvailable times. It is linked on the roomid field. Would you mind showing me how to add this join the to query.

Thanks
Kirk