• Sorry, I may have mislead you.

    The values under Relationship is taken from 2 tables.

    Table1 -> AssetID, AssetName

    Table2 -> Relationship1

    Table3 -> Relationship2

    Table4 -> Company

    Hence for each record I am getting duplicate values since one of the Relationship is null and the other has value

    The sample query I have something like:

    Select A.AssetID, A.AssetName, B.Relate as Relationship, C.Company

    from table and joins

    union

    Select A.AssetID, A.AssetName, B.Relatedby as Relationship, C.Company

    from table and joins