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
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