Here is the relationship I have:
first table ->one to many-> association table ->many to one-> second table ->one to many-> association table 2 ->many to one-> third table
I want to get fields from the second and third tables that are associated with the records from the first table, as there is only one record in the second and third tables that will correspond to the records I'm getting from the first table. I think I need an inner join query but I've only ever done it for a directly related table and not multiple tables, so it's beyond my abilities at this point and I'm having trouble knowing what exactly I need to search for. I greatly appreciate help!
Edit: so I'm a genius, I didn't have data in my association table... it's working now