Understanding SQL Join Types for use in Reporting/Collections within Altiris