• Dear,

    Use Union all operator to unified the result set.

    Go to : http://www.w3schools.com/sql/sql_union.asp

    Note. Datatype and no of columns should be same when you use union / union all,

    Cheers