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