(select distinct cno from borrow)
except
(select distinct cno from card)这么一句运行为什么错。。
消息 156,级别 15,状态 1,第 2 行
在关键字 'except' 附近有语法错误。
except
(select distinct cno from card)这么一句运行为什么错。。
消息 156,级别 15,状态 1,第 2 行
在关键字 'except' 附近有语法错误。
except
select distinct cno from card
except
select * from (select distinct cno from card) as b
应该是有except的、
select distinct cno from borrow
where not exists
(select distinct cno from card where borrow.cno=card.cno)