When you need to incorporate a filter to previously mentioned results depending on a relation like table1.id = table2.id You should utilize Internal JOIN: Theta-join is analogous to a Exclusive circumstance of interior join in which the on is usually a theta comparison on of a column from Each individual. https://jonathanc173wlb7.wikikali.com/user