羊水栓塞的抢救药品:帮我看下这个代码如何修改！

来源：百度文库编辑：杭州交通信息网时间：2024/05/10 05:36:26

sql = "select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where class1="&class1&" and yz=1 order by b desc"

如果我想调出数据库中列“yz"数值1或者为2的数据该如何修改上面的代码？
如果在yz=1后面加上or yz=2这样修改好象不行。我用的是Access数据库。谢谢指教

sql = "select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where class1="&class1&" and yz in ('1','2' ) order by b desc"
sql = "select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where class1="&class1&" and （yz=1 or yz=2) order by b desc"
sql = "select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where (class1="&class1&" or yz=1) and (class="&class1&" or yz=2) order by b desc"
任意一个都行

sql = "select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where class1="&class1&" and （yz=1 or yz=2) order by b desc"

select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where class1="&class1&" and (yz=1 or yz=2) order by b desc

sql = "select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where class1="&class1&" and yz in (1,2) order by b desc"

select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where chass1="&class1&" and yz=1 order by b desc;union select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where chass1="&class1&" and yz=2 order by
b desc
(我用的是SQL 2000)

如果yz字段是字符的话，应该为：
sql = "select id,biaoti,leixing,name,a,b,c,fbsj,llcs,hfcs from xinxi where class1="&class1&" and yz in ('1','2' ) order by b desc"

帮我看下这个代码如何修改！帮我看下这个代码什么意思。帮我看下这个网页背景颜色的代码是什么？请帮我修改下代码～～～大家看下我这个配置怎么样？帮我修改下！！帮我看下这个查询asp 代码什么意思,尽量详细地注解下帮我修改下这个翻译～～！！大家帮我看下这个配置如何啊 ? 帮我看下这个配置？？？帮我看下这个配置怎样？