OUTER Utilize: Comparable to Still left OUTER JOIN (But has the extra advantage of being able to compute something in the right desk for each row from the remaining desk and returns each of the rows from your left desk irrespective of a match on the right desk.)I feel the a lot quicker way is to put the filter inside the exactly where clause, mainl