When you need to incorporate a filter to higher than success based on a relation like table1.id = table2.id You should use INNER JOIN: (NB: In follow the question optimiser may locate a lot more economical ways of executing the query when compared to the purely logical description above, but https://louisjnles.bloggazzo.com/35550799/how-to-join-an-outlaw-motorcycle-club-book-for-dummies