10 Replies Latest reply: Sep 30, 2016 10:46 AM by Lawrence Bunnell RSS

    Outer Join without duplicates

    Lawrence Bunnell

      I'm trying to join two tables and keep records from both. Some of the record id/loan numbers are in both tables but some are not. I'm ending up with duplicates using an outer join. Is there a way to prevent this?

       

      Loan NumberOld Loan Number
      123455678901
      123455-
      123456-
      123457123051
      123457-