Home Forums SQL Server 2008 T-SQL (SS2K8) return results where value exists in another table RE: return results where value exists in another table

  • September 14, 2013 at 8:34 am

    #1650233

    You have a query that returns 99.9% of what you want. All that is needed is to subtract the 2 weights.

    select *, two.ITM$Weight - one.ITM$Weight as WeightDiff

    from etc . . .

    NOTE: Your expected output contained an error in the WeightDiff in the 2nd row.

    __________________________________________________________________________________________________________
    How to Post to get the most: http://www.sqlservercentral.com/articles/Best+Practices/61537/