sql查询where提交in的问题

例如有一张表 a 字段有
id score
1 80
2 90
3 100

我要给予一个查询条件 select * from a where id in (1,2,3,4,5) 

能否显示的结果为
1 80
2 90
3 100
4 0
5 0
表中不存在的也显示出来,分数默认为0
谢谢
要实现这种情况有哪些方法?程序或sql都行.

SQL code

;with cte as
(
  select 1 as row
  union 
  select 2
  union 
  select 3
  union
  select 4
  union
  select 5
)

select a.row,isnull(b.score,0) score
from cte a left join tb b on a.row = b.id

select b.id,isnull(a.score,0) as score
from
(select 1 as id union select 2 union select 3 union select 4 union select 5) b
left join a on a.id=b.id

SQL code

create table tb(id int,score int)
insert into tb select 1,80
insert into tb select 2,90
insert into tb select 3,100
go
select a.number,isnull(b.score ,0)score
from master..spt_values a left join tb b on a.number=b.id
where type='p' and a.number in(1,2,3,4,5)
/*
number      score
----------- -----------
1           80
2           90
3           100
4           0
5           0

(5 行受影响)

*/
go
drop table tb