求大虾帮忙简化简化一个SQL语句

[zhoujiao2008]

select *from ((select DrawingID,VoteName,DrawingName,ActivityName,DrawingTime
from  tblVOTEDrawingInfo a left join tblVOTEActivityInfo b on a.ActivityID = b.ActivityID
left join tblVOTEVoteItem c on a.Type = c.VoteID
where  Type in (select distinct VoteID from  tblVOTEVoteItem))
union
(select DrawingID,QuestionnaireName as Name ,DrawingName,ActivityName,DrawingTime 
from   tblVOTEDrawingInfo d left join tblVOTEActivityInfo e on d.ActivityID = e.ActivityID
left join tblVOTEQuestionnaireInfo f on d.Type = f.QuestionnaireID
where  Type in (select distinct QuestionnaireID from  tblVOTEQuestionnaireInfo)))
tblVOTEActivityInfo  where 1=1  and a.ActivityID='111111'

写完了这个SQL语句，但是觉得好麻烦，可以简化，来这里看看大家有没有可以简化一下这句的方法，求大虾们指点。

[PB菜鸟]

坐等专家简化，我写也基本上是这样。

[zhoujiao2008]

`~大虾在哪里啊~~

[發糞塗牆]

执行计划贴出来

[zhoujiao2008]

就是GRIDVIEW绑定的数据源啊。

[發糞塗牆]

你不知道我想问啥是吧？