• Minnu (3/21/2013)


    Table_1: ID | CHARACTER

    1A

    2B

    3C

    4D

    5E

    Tabe_2 : ID | CHARACTER

    1B

    2D

    3C

    Output should be :

    1 A

    2 B

    4 D

    5 E

    On what basis you are avoiding "C" OR how results comes here . what to include and what to exclude in results . Please clarify.

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)