表连接问题

[killed1988]

select a.m_Subject,a.m_TrainingExpense,a.m_ID,a.m_OpenType,
a.m_PlanStartTime,a.m_DuringTime,a.m_MaxAmount,a.m_Description,
count(b.att_AttendUserID) as currcount
from met_meeting as a inner join Met_Attendees as b
on a.m_id = b.m_id 
where a.m_id='100010000006726' and b.att_IsAttend = 1

提示错误:
消息 8120，级别 16，状态 1，第 1 行
选择列表中的列 'met_meeting.m_Subject' 无效，因为该列没有包含在聚合函数或 GROUP BY 子句中。


什么愿意导致的？？ 谢谢

[Lakers_24号程序员]

一、 b.m_id 必须出现在select 跟 from 之间 因为b.m_id没有被聚合函数修饰,

二、要吗你去掉后面的where以后的语句（包括where）

[tengjian1981]

select a.m_Subject,a.m_TrainingExpense,a.m_ID,a.m_OpenType,
a.m_PlanStartTime,a.m_DuringTime,a.m_MaxAmount,a.m_Description,
(select count(b.att_AttendUserID)
from met_meeting as a inner join Met_Attendees as b
on a.m_id = b.m_id
where a.m_id='100010000006726' and b.att_IsAttend = 1) as currcount
from met_meeting as a inner join Met_Attendees as b
on a.m_id = b.m_id
where a.m_id='100010000006726' and b.att_IsAttend = 1

[grearo]

select a.m_Subject,a.m_TrainingExpense,a.m_ID,a.m_OpenType,
a.m_PlanStartTime,a.m_DuringTime,a.m_MaxAmount,a.m_Description,
count(b.att_AttendUserID) as currcount
from met_meeting as a inner join Met_Attendees as b
on a.m_id = b.m_id 
where a.m_id='100010000006726' and b.att_IsAttend = 1
group by m_Subject ,m_TrainingExpense,m_ID,m_OpenType,m_PlanStartTime,m_DuringTime,m_MaxAmount,m_Description

[Lakers_24号程序员]

[Quote=引用 3 楼 grearo 的回复:]
SQL codeselect a.m_Subject,a.m_TrainingExpense,a.m_ID,a.m_OpenType,
a.m_PlanStartTime,a.m_DuringTime,a.m_MaxAmount,a.m_Description,
count(b.att_AttendUserID) as currcount
from met_meeting as a inner join Met_Attendees as b
on a.m_id = b.m_id
where a.m_id='100010000006726' and b.att_IsAttend = 1
group by m_Subject ,m_TrainingExpense,m_ID,m_OpenType,m_PlanStartTime,m_DuringTime,m_MaxAmount,…
[/Quote]


非常好