22,209
社区成员
发帖
与我相关
我的任务
分享
select NAME from card JOIN (SELECT CNO FROM BORROW
join BOOKS on BORROW.BNO=BOOKS.BNO WHERE BNAME in ('计算方法','组合数学')
group by CNO having count(BORROW.BNO)=2 )BORROW ON card.CNO=BORROW.CNO
select s.sno,s.snamefrom s,(select sc.sno from sc,cwhere sc.cno=c.cnoand c.cname in('1','2')group by sno having count(distinct cno)=2)sc where s.sno=sc.sno