Joining 2 Tables and Eliminating the Redundant Data

• Jol

  SSC-Addicted

  Points: 429

  More actions

  April 6, 2006 at 10:20 am

  #365839

  Hi All,

  I have a following scenario

  Table A

  usr city

  jo sf

  jo la

  Table B

  usr city

  jo nyc

  when I create a join on usr field I get a result like

  usr city usr city

  jo sf jo nyc

  jo la jo nyc

  How can I eliminate the redundant data from table 2..

  I want my result to be something like this

  usr city usr city

  jo sf jo nyc

  jo la Null Null

  Any help would be highly appreciated...

  Thanks

  Jol

  ---

  Kindest Regards,

  Joel

• Sameer Raval

  Hall of Fame

  Points: 3214

  More actions

  April 6, 2006 at 12:44 pm

  #631333

  Jol,

  Please do not post same question at multiple places.

  Your question is answered in administration

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=271655#bm271701

  Kindest Regards,

  Sameer Raval [Sql Server DBA]
  Geico Insurance
  RavalSameer@hotmail.com