select question,answer from Subject where subjectID in (1,2,3)是支持的,但是如下的SQL,在access中就是不支持。
select question,answer from Subject where subjectID in (select subjectID from QuizActivity where activityID=55 union select subjectID from TimerSendInfo where activityID =55)
如果需要实现这种功能,只能程序控制了,例如:
![](https://i-blog.csdnimg.cn/blog_migrate/6810355c2f78c12e91b7997a8e8c583a.gif)