I’m quite new and currently I’m facing a problem. It’s the last step for my MVP.
I don’t know how to properly join my tables and it’s driving me crazy. I’m tackling this problem since 8 hours and hopefully someone can help me.
Basically I have the following tables: Event, Organizer, Discipline, Category, Event_Category, Event_Discipline.
This is how my models and schema looks:
And now I’m wondering how to join these tables to one single table where select everything except the ids.
My last state was this:
use crate::database::schema::*; let join = event::dsl::event .inner_join( organizer::dsl::organizer.on(organizer::id.eq(event::fk_organizer_id)), ) .inner_join( event_category::dsl::event_category .on(event_category::fk_event_id.eq(event::id)), ) .inner_join( event_discipline::table.on(event_discipline::fk_event_id.eq(event::id)), );
I really appreciate any help!