Combining two tables effectively

[jimstuart]

Hi all,

I'm trying to retrieve information in the most useful way but can't seem to find a way that seems right. Sure I'm missing something.

My tables -

room_bookings -

number | startTime | endTime | employee
1 | | |
2 | | |
3 | | |

booking_clashes -

number | clasheswith
1 | 2
1 | 3
2 | 3


The clashes are created if somebody has booked a room that overlaps with somebody else's booking. As you can see there can be multiple clashes.

I'd like to be able to do some sort of join between these tables so that I can select from the room_bookings and have the clashes in with that row.

Hope that makes sense,
Jim

 

[TheSQL]

SELECT rb.Number, rb.StartTime --Add in whatever else you want to select
FROM room_bookings rb
WHERE rb.Number IN (SELECT NUMBER FROM booking_clashes)

Hope this helps.