Level 12
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?
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;
Please or to participate in this conversation.