1,216
社区成员
发帖
与我相关
我的任务
分享怎么组合查询阿？？小问题！！虾米请教各位高手
rs.Open "SELECT * FROM [total] WHERE [temporalboxnumber]=" + "'" + myvalue + "'" + "ORDER BY [warecode],[serialnumber] ASC", cn, adOpenStatic, adLockReadOnly
这样只能查一个temporalboxnumber，如果要俩个
[temporalboxnumber]=myvalue1
[id]=myvalue2
该怎么写啊
这样只能查一个temporalboxnumber，如果要俩个
[temporalboxnumber]=myvalue1
[id]=myvalue2
该怎么写啊
...全文
请发表友善的回复…
发表回复
creationbj 2002-12-17
- 打赏
- 举报
and
zhenxizhou 2002-12-16
- 打赏
- 举报
rs.Open "SELECT * FROM [total] WHERE [temporalboxnumber]=" + "'" + myvalue + "'" and id=" + '" +myvalue2+"'" + "ORDER BY [warecode],[serialnumber] ASC", cn, adOpenStatic, adLockReadOnly
songfeng163 2002-12-16
- 打赏
- 举报
rs.Open "SELECT * FROM [total] WHERE [temporalboxnumber]=" & "'" & myvalue & "' and [id]='" & myvalue2 & "' ORDER BY [warecode],[serialnumber] ASC", cn, adOpenStatic, adLockReadOnly
传送门：http://seekerlee.github.io/Sound-Pirate/支持豆瓣FM，豆瓣音乐人，虾米，Songtaste，落网，人人电台，QQ音乐，网易云音乐，新浪乐库，搜狗音乐等.
