How can I query the "many" entities in a one-to-many relationship but only retrieve ones where the parent (the "one" in one-to-many) has a column with a certain value? My database has a sessions table and actions table, where each action can have many sessions but each session can only have one action. I'd like to query for all sessions where their related action has a "goal" column with a certain value. How do I go about this?

Hello @swiss! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.