sql server 2005 - Sql Null Value On One Column Partition -

i waste 2 3 hourse behind sql transact , confused on null value skip.

i have 2 table below:

table 1: accountmast companyid   accname         category 102     purchase  account   purchase account 102     sales account       sales account  table2: legder  companyid   name             102     purchase account         102     sales account        

i have join below:

select case when a.catagory='purchase account' l.name  end purchaseaccount, case when a.catagory = 'sales account' l.name    end salesaccount ledger l join accountmast on l.companyid=a.companyid , l.name = a.accname l.companyid=102 , a.catagory='purchase account' or a.catagory='sales account' group l.name,a.catagory 

the result is:

purchaseaccount     saleaccount purchase account    null null                sales account 

but want result like:

purchaseaccount     saleaccount purchase account    sales account 

how it?

remove group by clause:

select     max(case when a.catagory = 'purchase account' l.name end) purchaseaccount,     max(case when a.catagory = 'sales account' l.name end) salesaccount ledger l join accountmast on l.companyid = a.companyid , l.name = a.accname l.companyid=102 , a.catagory in ('purchase account', 'sales account')