求一SQL语句！

[fusoft]

表 Album（相册）

ID Name PicCount
---- ---- ----
1 aaa 0
2 bbb 2
3 ccc 1
...

表 Photo (图片)

ID AlbumID Name
---- ---- ----
1 2 aaa.jpg
2 2 bbb.jpg
3 3 ccc.jpg

读取表Album所有相册列表
如果该相册PicCount >0 则 从表Photo中按ID排顺序取出一张图片的Name
如果该相册PicCount =0 则 返回Null

[-狙击手-]

select a.* ,
case when piccount > 0 then (select top 1 name from photo where albumid = a.id order by id)
      else null
      end
from album a

[xiaoku]

select a.* ,b.Name  
from Album a left join (select AlbumID ,name from Photo t where not exists (select 1 from Photo where t.AlbumID=AlbumID and a.ID>ID )) b on a.ID= AlbumID 

[pt1314917]

select a.id,a.name,case when a.piccount>0 then c.name else null end 
from album a,(select * from photo b where not exists(select 1 from photo where albumid=b.albumid and id<a.id))c where a.id=c.albumid

[昵称被占用了]

select a.* ,b.Name  
from Album a left join Photo B on a.ID= AlbumID and a.PicCount >0

[昵称被占用了]

select a.* ,b.Name  
from Album a left join Photo B on a.ID= AlbumID and a.PicCount >0
and not exists (select 1 from Photo where AlbumID=b.AlbumID and id<b.Id)