数据库
关注
分享
扫一扫
iteye_2173
这个作者很懒，什么都没留下…
展开
-
exists
select * from tbInformation as i where exists(select it.id from tbInfoType as it where it.schoolID=247 and it.id = i.typeID) and scope like '%老师%' and typeID = 10017原创 2014-03-13 10:55:42 · 115 阅读 · 0 评论 -
exists
select count(*) from NetTeacherStudent as nts where exists(select id from NetTeacher as nt where nt.user.username='"+username+"' and nts.teacher.id=nt.id)原创 2014-09-02 11:42:28 · 146 阅读 · 0 评论