When you need to include a filter to previously mentioned outcomes depending on a relation like table1.id = table2.id You may use Interior JOIN: Theta-join is analogous to the Unique scenario of inner join exactly where the on can be a theta comparison on of a column from Every single. https://holdengszeh.bloggerbags.com/42022776/5-simple-statements-about-how-to-join-outlaw-motorcycle-club-book-explained