12楼: Originally posted by adong76 at 2013-10-21 20:16:27
表名和列名写错了，改为：
select r1.lno from loan r1
where r1.bno='0287' and exists(
        select * from loan r2 where r2.bno='0398'
                and r1.lno=r2.lno)...

2楼: Originally posted by hx_zm at 2013-10-20 16:27:58
select lno from Loan where  BNO = '0287'  and lno in (select lno from Loan where  BNO = '0398' )

3楼: Originally posted by 淡淡0987 at 2013-10-20 22:07:47
这个不对，至少借阅，不是只借阅...