一个简单的问题,在线等待!

[willway]

同个 数据库,想同时select docchannel分别等于1,2,3,4,按时间的先后自动排列,这个应该怎么写?
rs.open "select * from BOOK where docChannel=1 or docChannel=2 or docChannel=3 or docChannel=4 ororder by docdate desc,好像不对

[willway]

最后多了一个or,打错的

[firedragon8]

select * from book where docchannel=1 order by docdate desc union
select * from book where docchannel=2 order by docdate desc union
select * from book where docchannel=3 order by docdate desc union
select * from book where docchannel=4 order by docdate desc

[wzhiyuan]

1。
select * from BOOK where docChannel=1 or docChannel=2 or docChannel=3 or docChannel=4 order by docdate desc
你多打了个or
2,选择项多时，你用如下这样的形式更简洁：
select * from BOOK where docChannel in(1,2,3,4)

[syd41]

关注！