When you need to add a filter to above effects according to a relation like table1.id = table2.id You may use Interior JOIN: Correct Outer Join. Exact as inner join, then for virtually any rows in the appropriate desk that did not match anything at all, output these with NULL https://ricardopdjqy.blogchaat.com/36753889/the-basic-principles-of-how-to-join-a-outlaw-motorcycle-club