When you need to include a filter to above outcomes depending on a relation like table1.id = table2.id You may use Interior JOIN: Theta-join is analogous into a Distinctive situation of internal join exactly where the on is actually a theta comparison on of a column from Every. Some decades https://arthurdjkih.blogocial.com/a-simple-key-for-how-to-join-a-outlaw-motorcycle-club-unveiled-72331645