Help w/ Duplicate Results

  • 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>

  • Sorry I had duplicates in my table.


    </cm>

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply