hmm tried this approach but kept on getting an error.....

I however was able to solve the problem. I used Left Outer Join instead of Inner Join and moved the WHERE...