Home Forums SQL Server 2005 T-SQL (SS2K5) Merging rows RE: Merging rows

  • October 5, 2012 at 6:19 am

    #1546021

    Mark-101232 (10/5/2012)

    Try this

    SELECT AssetID, AssetName, MAX(Relationship) AS Relationship, MAX(Company) AS Company

    FROM myTable

    GROUP BY AssetID, AssetName

    Thanks Mark, but the problem is "Relationship" and "Company" columns are from different tables. Hence using two Select queries with a Union

    Where as AssetID and AssetName are from a single table. Therefore there are 3 tables involved