When you need to add a filter to over effects according to a relation like table1.id = table2.id You should use INNER JOIN: (NB: In follow the query optimiser may possibly find more successful means of executing the question compared to the purely logical description over, but the ultimate consequence https://lukasvfrke.articlesblogger.com/58950407/5-simple-statements-about-how-to-join-outlaw-motorcycle-club-book-explained