• Thank's for you Replay.

    The scenario is

    Server 1:

    ID Address

    -------------------

    1 USA

    2 UK

    3 IND

    Server 2:

    ID Address

    ----------------

    1 Singapur

    2 UK

    3 IND

    My goal is to get the the out of sync data from the servers

    In the above example, In server1 we have value USA for Id 1 and in server2 we have value singapur.

    I have the Ids based on Ids I Need to check the data.

    Expected result is:

    ID ValueInserver1 Valueinserver2 DiffColumnname

    --------------------------------------------------------------------

    1 USA Singapur Address