我有个sql:

[msuxx]

我有个sql:
select t.studid,t.grade from transcript t
where t.grade='A' group by t.studid ,t.grade
having count(*)=????????


我想让????????????的值等于下面的count（＊）的值，如何连接２个sql　呢？
select count(*) as ttt,studid from transcript group by studid)

原题目如下：
找出所有每门课程都是Ａ的学生的最小年龄．
表结构如下：
create table STUDENT
(
STID INTEGER not null,
STNAME CHAR(20) not null,
STADDRESS CHAR(50) not null,
STSTATUS CHAR(10) default 'freshman',
STAGE INTEGER not null
)
create table TRANSCRIPT
(
STUDID INTEGER,
CRSCODE CHAR(6),
SEMEATER CHAR(6),
GRADE CHAR(1)
)

[zlp321002]

select t.studid,t.grade from transcript t
where t.grade='A' group by t.studid ,t.grade
having count(*)=(
select count(*) from transcript where studid=t.studid
)

[zlp321002]

--try
select STNAME from STUDENT A
where not exists
(select 1 from STUDENT where STAGE>A.STAGE)
and STUDID in
(
select STUDID from TRANSCRIPT
where GRADE='A'
group by STUDID,CRSCODE
)

[$扫地僧$]

Try:
select top 1 * from STUDENT
where STID in
(select STUDID
from TRANSCRIPT
where STUDID not in(select STUDID from TRANSCRIPT where GRADE<>'A'))
order by STAGE

[msuxx]

谢谢上面2位的提示,可能是我的描述有些问题,因该是找出一个学生他所有的课程都是A 同时他的年龄是所有都是A的学生里面最小的.