9 Replies Latest reply on Jul 27, 2018 12:14 PM by Ben Perlman

    Left join duplicating data?

    Ben Perlman

      I'm having problems with a join via 2 sql servers.  One has client name, date, and data I need.  The other has client name + a separate client association code that I am trying to bring in. No date or anything, only bringing in 2 columns.  I'm doing a left join by client name to the bigger database.  For some reason though, it is duplicating data when I do this.  I can't think of why it would be.  It is my understanding it would just be including the string for each line, but not adding any lines, so can't figure out why it is altering the data from the main data source by just adding the join? any ideas?