I have a question about how to get records that are related but are several tables away. As an example:
I have the following model:
A Course has Sessions (times the course run).
Sessions are associated with Users through an association table.
So, what I want to do is bring back all Courses and sessions for a particular user (for a particular time period). How would I bring this data back using a relational model?