Still in progress...

Why am I using Left Outer Joins instead of Inner joins? Is this wrong? What should I be using?