大家帮忙看个T-SQL语句问题？

[rwh871212]

有三张表，我先是根据通过类型表newsclass（name）的ID 好和news(type)关联的得到news 表的ID，再通过imgList 的(type)和newsclass（name）关联，想通过另一个程序上传一张图片得到news表的ID，可如果按news(updatedate)排序，查出来的news表的ID一样，按 imgList （updatedate）排序，查出来的imgList 表的图片字段（img）一样，请问怎么解决，高手指导？
code=C#]
select * from newsclass where name ='企业风采'
select * from news where type ='6efabe27-c274-4106-8560-9f012536e9bb'
select * from imgList where type ='企业风采 '
[/code]



我写的代码如下：

 select top 4
            X.Id,X.title,X.context,X.name,X.type,X.img,X.updatedate ,X.date from
            (
            select distinct NW.Id,NW.title,NW.context,NW.updatedate as updatedate,NC.name,IG.type,IG.img ,IG.updatedate as date
            from news as NW
            left join newsclass as NC on NW.type =NC.id
            left join ImgList as IG on NC.Name =IG.type
            )as X
            where X.type ='企业风采'
            order by X.date desc

出现问题的效果如下：
id相同：


图片相同

[md5e]

用left outer join

[yan267]

select top 4  NW.Id,NW.type,NW.title,NW.context,NW.updatedate,NC.name
            from news as NW
            left join newsclass as NC on NW.type =NC.id
            left join ImgList as IG on NC.Name =IG.type
where IG.type='企业风采'
GROUP BY NW.Id,NW.type,NW.title,NW.context,NW.updatedate,NC.name
order by NW.updatedate desc,IG.updatedate desc

[rwh871212]

[Quote=引用 1 楼 liuchaolin 的回复:]
用left outer join
[/Quote]

试了，不行呀？

[rwh871212]

[Quote=引用 2 楼 yan267 的回复:]
SQL code


select top 4 NW.Id,NW.type,NW.title,NW.context,NW.updatedate,NC.name
from news as NW
left join newsclass as NC on NW.type =NC.id
left join ImgList……
[/Quote]

我试过了也是不行

[rwh871212]

 select top 4
            X.Id,X.title,X.context,X.name,X.type,X.img,
X.updatedate ,X.date from
            (
            select distinct NW.Id,NW.title,NW.context,NW.updatedate as updatedate,NC.name,IG.type,IG.img ,IG.updatedate as date
            from news as NW
            left join newsclass as NC on NW.type =NC.id
            left outer  join ImgList as IG on NC.Name =IG.type
            )as X
            where X.type ='企业风采'
			group by  X.Id,X.title,X.context,X.name,X.type,X.img,X.updatedate ,X.date
            order by X.updatedate,X.date desc

图片不同ID相同

[md5e]

select top 4
X.Id,X.title,X.context,X.name,X.type,X.img,X.updatedate ,X.date from
(
select distinct NW.Id,NW.title,NW.context,NW.updatedate as updatedate,NC.name,IG.type,IG.img ,IG.updatedate as date
from news as NW
left join newsclass as NC on NW.type =NC.id
left join ImgList as IG on NC.Name =IG.type and IG.title=NW.title
)as X
where X.type ='企业风采'
order by X.date desc
少了一个关联

[rwh871212]

[Quote=引用 6 楼 liuchaolin 的回复:]
select top 4
X.Id,X.title,X.context,X.name,X.type,X.img,X.updatedate ,X.date from
(
select distinct NW.Id,NW.title,NW.context,NW.updatedate as updatedate,NC.name,IG.type,IG.img ,IG.updatedate……
[/Quote]

select top 4
X.Id,X.title,X.context,X.name,X.type,X.img,X.updatedate ,X.date from
(
select distinct NW.Id,NW.title,NW.context,NW.updatedate as updatedate,NC.name,IG.type,IG.img ,IG.updatedate as date
from news as NW
right join newsclass as NC on NW.type =NC.id
right outer join ImgList as IG on NC.Name =IG.type
)as X
where X.type ='企业风采'
group by X.Id,X.title,X.context,X.name,X.type,X.img,X.updatedate ,X.date
order by X.updatedate,X.date desc

[rwh871212]

[Quote=引用 6 楼 liuchaolin 的回复:]
select top 4
X.Id,X.title,X.context,X.name,X.type,X.img,X.updatedate ,X.date from
(
select distinct NW.Id,NW.title,NW.context,NW.updatedate as updatedate,NC.name,IG.type,IG.img ,IG.updatedate……
[/Quote]

不好意思，看错了，好想可以我测一下