SQL语句请教

[jackyrong]

在一个视图中，构成如下
ID AA BB cc ...
1 123 ss s
1 4535 fdf s
1 60 dfdf s
1 61 ad s
2 50 dff x
2 60 gfg x
3 89 fgf s
4 40 fg x
上表中，id,AA,BB,CC为字段名，其中每个ID可以对应多个 AA，现在的问题是要求
筛选出CC字段中值为S（或为X）的所有记录，但筛出来的只需要下面这样就可以了，

ID AA BB CC
1 .... ....
3 .... ....
就是ID为唯一的，有什么好的办法呢？
我试过（ACCESS 2000中）用
select ID,MAX(AA) AS AA,MAX(BB) AS BB from tName where cc='s' group by ID
但不行

[40Star]

select distinct ID ,AA,BB,CC From tName Where cc='S'

[jackyrong]

这是不行的咯，试过了

[neweb]

select a.aa,a.bb,a.cc,b.id from tab,(select distinct ID From tName) as b where a.id=b.id and (a.cc='S' or a.cc='X')

[希偌]

你既然只需要选出唯一的id,是否意味着要丢失一些数据？
没看懂你的意思！

[KnowLittle]

select * from table where id in (select id from table where cc='s' group by id)

[hehongyu2000]

Try it.
select distinct
tna.id,
aa = (select top 1 aa from tname where id = tna.id),
bb = (select top 1 bb from tname where id = tna.id),
tna.cc
from tName tna
where tna.cc = 's'