0 Replies Latest reply: Oct 24, 2012 6:15 AM by brytesikaz RSS

    Help with duplicate fields using joins

      Hi guys,

       

      I have two tables whrere am outer joining one with the other but the problem is it is giving a result like below where if a person belows to External it duplicates the record with an empty on but if they below to BSERVE then its fine

       

      Source
      BSERVE
      INTERNAL

       

      source IDITYPE
      22External
      22
      34BSERVE
      36BSERVE
      37External
      37

       

      any ideas?

       

      thanks