日期:2014-05-17  浏览次数:20743 次

这句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= '教育随笔 ' ', ' '健康快车 ' ', ' '幼儿园动态 '
)
)