• Thanks SSCrazy. Union all does not work in my case as i do not want two rows .........

    but left join worked.. thanks.