Currently working on getting my head around the ordering of things, not even with laravel at first, but sql. Though the end goal is to use eloquent.
There are 2 conditions for the rows that need to be excluded. If I’m fetching the rows from TableA..
1) TableA with the column status_id (or TableC.id) has to have lets say a value of 1.
2) TableB has to have an instance for that TableA.id where status_id (or TableC.id) is lets say 2.
Been looking at whereNotIn, whereExists and when for a while now, but can’t wrap my head around what is correct for the situation and how it should look like.
Still learning about sql queries and I am very grateful for any tips on this dilemma.
from Newest questions tagged laravel-5 – Stack Overflow https://ift.tt/2X5qzLG