当前位置: 代码迷 >> ASP >> 这句SQL语句如何改呢
  详细解决方案

这句SQL语句如何改呢

热度:175   发布时间:2012-02-11 09:51:34.0
这句SQL语句怎么改呢?
select   bid,board   from   board   where   admin_id=70   and   (board   not   in   (select   board   from   board   where   board= '闲来一家人 '   or   board= '教育随笔 ', '健康快车 ', '幼儿园动态 '))
提示出错?


------解决方案--------------------
select bid,board from board where admin_id=70 and board not in ( '闲来一家人 ', '教育随笔 ', '健康快车 ', '幼儿园动态 ')

------解决方案--------------------
select bid,board from board where admin_id=70 and
(
board not in
(
select board from board where board= '闲来一家人 '
or board= '教育随笔 ' ', ' '健康快车 ' ', ' '幼儿园动态 '
)
)
  相关解决方案