When you need to incorporate a filter to earlier mentioned results based on a relation like table1.id = table2.id you can use Interior JOIN: In this kind of a JOIN, we get all data that match the situation in both of those tables, and information in both of those tables https://tysonevjxi.win-blog.com/17819613/a-secret-weapon-for-how-to-join-outlaw-motorcycle-clubs-book