When you need so as to add a filter to higher than effects determined by a relation like table1.id = table2.id You may use Internal JOIN: I choose the JOIN to join entire tables/Views and afterwards make use of the Exactly where To introduce the predicate on the resulting established. https://zanerglkm.thezenweb.com/5-simple-techniques-for-how-to-join-outlaw-motorcycle-clubs-75410418