2条select语句怎样才能把数据写在一起！
ACCESS数据库，select语句如下：
select * from company where area_id like '" & a_id &",%' and verify=0 and commend=1 and DateDiff ('d',date(),commend_endtime)>=0 and DateDiff ('d',date(),commend_begintime)<=0 order by commend desc,allcommend desc,commend2 desc,commend1 desc,commend0 desc,count desc
'上面语句得出有效时间内审核后的信息
select * from company where area_id like '" & a_id &",%' and verify=0 order by count DESC
'上面语句得出有效时间结束、普通的信息
要注意的是，一定要分别按照上面排序来分别排序...
select * from (select * from company where area_id like '" & a_id &",%' and verify=0 UNION select * from company where area_id like '" & a_id &",%' and commend=1 and verify=0 and DateDiff ('d',date(),commend_endtime)>=0) order by commend desc,allcommend desc,commend2 desc,commend1 desc,commend0 desc,count desc
这条是我自己写的，没有得到理想答案
