不对因为你的子查询里面不包括Title
而且根本不需要用子查询
如下:select id ,title from lateclass where lateid =in (1,2) and title = "xxx";MappingName就是id,Title
而且根本不需要用子查询
如下:select id ,title from lateclass where lateid =in (1,2) and title = "xxx";MappingName就是id,Title
Select ID,Title From (Select ID,Caption,Title From LateClass Where LateID=1 or LateID=2) Where Title="xxx"MappingName就是id,Title