SQL Server - how to make duplicate row come colum as zero when left join with two select query

Asked By mani on 03-Apr-13 03:58 AM
hi..any one help me in this issue..

hi..i have two select query and i have  used left join with those queries..and left query return single row and right query return two rows..when using left join first select table return duplicate rows..i need to make duplicated columns as zeroes..any help please..hope it will be understandable....

thanks in advance..