Help w/ Duplicate Results

• cmcilvoy

  Ten Centuries

  Points: 1015

  More actions

  July 7, 2002 at 10:41 am

  #158604

  I get duplicate rows in my results. I am sure it is my query:

  SELECT

  FSP2.edp,

  FSP2.sku,

  FSP2.sizevalue + ' ' + FSP2.colorvalue AS sizecolor

  FROM

  dbo.FSKitComponent

  inner JOIN

  dbo.FSProducts FSP2 ON dbo.FSKitComponent.ComponentShortSku = FSP2.shortsku

  inner JOIN dbo.FSKits FSK ON dbo.FSKitComponent.ComponenetEDP = FSK.ComponentEDP

  inner JOIN dbo.FSProducts FSP ON FSK.KitEDP = FSP.edp

  WHERE

  (FSP.shortsku = @shortsku)

  thanks

  
  </cm>

• cmcilvoy

  Ten Centuries

  Points: 1015

  More actions

  July 7, 2002 at 10:43 am

  #432156

  Sorry I had duplicates in my table.

  
  </cm>