子查询

select people from people where CityID =(select CityID from S_City where CityName like '%北京%') and goupId=(select goupId from goup where goupName like '%专家%')

posted @ 2014-12-22 16:25  fleam  阅读(127)  评论(0编辑  收藏  举报