left outer joins

When analyzing customer activity across systems, left outer joins helped me retain customers present in the main table even if they had no matching records elsewhere.