俩表连接问题

[cjavavb]

表1 表2
NO BOOK BOOK AUTHOR
125 b12 b01 wang
125 b13 b12 li
b13 b13 li
124 b12 b42 zhao
124 b12 b65 zhao
123 b65
122 b42
122 b01

如上为图书馆例子，NO为学号 ，要找出所有读了li 写的“所有”的书的学生学号。如上即为从表1 里选出 125
怎么办啊？？ 我只会建个临时的view 再从里面挑
最好解释下阿，谢谢！！

[cjavavb]

高手帮忙啊

[cjavavb]

高手睡觉去了？？
呵呵
醒了来也行啊

[eastbroth]

select no from b1 where book in(select book from b2 where hotbor=li)

[giftzyx]

SELECT TBL1.NO FROM TBL1 JOIN TBL2 ON TBL1.BOOK=TBL2.BOOT AND TBL.AUTHOR='li';

[giftzyx]

sorry,刚才笔误

SELECT TBL1.NO FROM TBL1 JOIN TBL2 ON TBL1.BOOK=TBL2.BOOK AND TBL2.AUTHOR='li';

[懒得去死]

select distinct(NO) from b1 where strcmp(AUTHOR,'li') = 0;

[brisking]

应该差不多了啊,

select no from
(
select distinct * from b1 where book in(select book from b2 where hotbor=li)
) as a
group by no
having count(*)>1

[brisking]

抱歉,我写的那个是错的.

[cjavavb]

不好意思啊
都不太~~~~对~~~~~

[chh1102]

select no from table1 join table2 where author="li" and table1.book=table2.book;