[RESOLVED] SQL query help

Hi,

I have 3 tables, I need to extract information about rooms that are allocated to events using the roombooking table.

My sql knowledge is very poor though and I have to use loads of queries.

Can anyone tell me how I can do this?

Thankyou

event

eventID - PK
startdate
enddate
eventtitle
eventdescription
recurring

BookingID - PK
eventID
roomID

roomID - PK
roomName
roomDescription
roomMaxTables
roomMaxChairs
roomCost

SELECT room.* FROM room
LEFT JOIN roombooking USING(roomID)
LEFT JOIN event USING(eventID)
WHERE eventID = ... (or any other condition)

thankyou