mysql查询第一条数据为空_数据库查询为空数据问题

select

(select isnull(count(*),0) from RoomContract

where PayModel = '按揭') as '按揭',

(select isnull(count(*),0) from RoomContract

where PayModel = '分期') as '分期',

(select isnull(count(*),0) from RoomContract

where PayModel = '一次性') as '一次性'

from RoomContract

select

ISNULL(sum(Receivable),0.00) as '学费收入',

(select ISNULL(sum(Total),0.00) from dbo.BookSellPay

where BookPayName='教材销售缴费' ) as '教材收入',

(select ISNULL(sum(IncomeMoney),0.00) from dbo.OtherIncome) as '其它收入'

from dbo.PaymentDetails

两条查询语句一样的 但查询出来的结果不一样

第一条

按揭     分期    一次性

没数据的话 就为空   isnull 函数好像没用，但第二条就可以

学费收入      教材收入     其它收入

0.00           0.00          0.00

怎样让第一条语句和第二条查询出来的结果一样呢