• first the records from both tables will be clubbed then UNION will distinct the records.

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