When you want to add a filter to higher than results dependant on a relation like table1.id = table2.id You may use Internal JOIN: Correct Outer Join. Similar as inner join, then for any rows in the best desk that didn't match something, output these with NULL values for your https://whitemagicspellsbooks25678.slypage.com/37820612/the-smart-trick-of-how-to-join-outlaw-motorcycle-club-that-no-one-is-discussing