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)
如果需要实现这种功能,只能程序控制了,例如:
DataTable dt1
=
new