GSherwin's avatar

Multiple Tier Queries

I have a table that joins to another table, then that table joins to another table, Can this be done in laravel. Here is the SQL code that works in MySQL.

SELECT actions.actionItem, actions.createdByID, project.program_id, project.level_1, project.level_2, program.programName FROM actions LEFT JOIN (program RIGHT JOIN project ON program.program_ID = project.program_id) ON actions.projectID = project.project_id;

0 likes
4 replies
PatrickSJ's avatar

Just to confirm, but you want all actions that have projects that lack programs?

Are your classes setup such that there is a relationship directly from action to project?

Please or to participate in this conversation.