I'm trying to generate a custom report via SQL (and jDBReports) and I'm trying to link (JOIN) 'bookings' with the 'event', but I can't tell how the bookings table (_matuko_bookings) is 'related' to the main '_matuko' table?
I can't find which field in _matukio_bookings should be JOINED to what field in _matukio.

Am I missing something?

I just need to create an SQL join between the event data and the bookings data.

Can you tell me what tables/fields would do that?

Thanks.