update usernum set yn='是' where
test=(select examination ,test,yn from usernum
where yn ='否'
and test
in
(select bkh from information group by bkh))报错当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式。
test=(select examination ,test,yn from usernum
where yn ='否'
and test
in
(select bkh from information group by bkh))报错当没有用 EXISTS 引入子查询时,在选择列表中只能指定一个表达式。
解决方案 »
- 转换控件类型两种方法有什么不同?
- 实现类似百度,Google的输入提示
- 实现datagrid的标题栏隐藏问题?
- 如何用asp.net 实现??
- “NHibernate.Proxy.CastleProxyFactory”的类型初始值设定项引发异常
- 正则表达式取值<a href="aaaaaaaaaa">bbbbbbbbb</a>的问题
- 菜鸟问题:源码管理?
- 请教:如何区分inputfile的image/pjpeg中的JPEGs和Progressive JPEGs
- 如何把客户端的目录列表及文件显示在ListBox中或网页中
- .NET.Framework安装问题(初学问题)--火急
- JQuery问题
- 做了一个asp.net的网站准备上传的服务器上,请问备份的数据库放到哪文件下呢?
test in (select examination ,test,yn from usernum
where yn ='否'and test in (select bkh from information group by bkh))
test=(select test from usernum where yn ='否' and
test in (select bkh from information group by bkh))
test in (select test from usernum where yn ='否' and
test in (select bkh from information group by bkh))
test=(select test from usernum
where yn ='否'
and test
in
(select bkh from information group by bkh))