• ...and I would recommend specifying the join type for readability if using the improved ANSI joins:

    INNER JOIN (default)

    RIGHT OUTER JOIN

    LEFT OUTER JOIN etc etc

    Robert Murphy, Microsoft MCITP (Database Administrator 2008) and MCAD Certified