34,590
社区成员
发帖
与我相关
我的任务
分享
select distinct infant.infantId,infantName,isnull(t.teacherName, '') master,city,country,address,infant.type,t.publicPhone,t.selfPhone,t.Email,t.QQ,postId,isnull(d.teacherCount,0) teacherCount,infant.memo
from infant left join (Select a.* from teacher a where teacherName = (Select top 1 teacherName from teacher where teacherWork = '园长' and infantId=a.infantId)) t on infant.infantId=t.infantId right join (select infantId , count(*) teacherCount from teacher_active b, active c where b.activId = c.activId and c.userId = '1' group by infantId) d on infant.infantId = d.infantId right join infant_active inf_a on infant.infantId = inf_a.infantId inner join active c on inf_a.activid=c.activid where c.activYear between '2006' and '2007' order by infant.infantId
select distinct infant.infantId,infantName,isnull(t.teacherName, '') master,city,country,address,infant.type,t.publicPhone,t.selfPhone,t.Email,t.QQ,postId,isnull(d.teacherCount,0) teacherCount,infant.memo
from infant
left join (Select a.* from teacher a where teacherName = (Select top 1 teacherName from teacher where teacherWork = '园长' and infantId=a.infantId)) t on infant.infantId=t.infantId
right join (select infantId , count(*) teacherCount from teacher_active b, active c where b.activId = c.activId and c.userId = '1' group by infantId) d on infant.infantId = d.infantId
right join infant_active inf_a on infant.infantId = inf_a.infantId
inner join active c on inf_a.activid=c.activid
where c.activYear between '2006' and '2007' order by infant.infantId