Select question

Dear All

I have the follow table:

Table 1 : AUTHOR

CALLNUMBER    FNAME        LNAME
Call123                  Hello            Homer
Call124                  Hello            Homer
Call125                  Jack              Collins
Call126                  Jack              Collins
Call127                  Winston        Churchill
Call127                  John             Keegan
Call128                  Jeff               Tanenbaum
Call129                  Carlos           Tanaka

Table 2 : BOOK

BORROWERMEMNO BORROWDUE CALLNUMBER LIBCHECK

123                                12-DEC-00         Call123
202
125                                11-NOV-00        Call123
201
124                                09-JUN-00         Call124
201
125                                11-NOV-00        Call124
201
125                                11-NOV-00        Call125
201
125                                11-NOV-00        Call126
201
124                                09-JUN-00         Call126
202
125                                11-NOV-00        Call128
201
126                                10-OCT-00         Call128
202
123                                12-DEC-00         Call129
202
125                                12-DEC-00         Call129

I want to write a SQL to list the borrowermemno of all the members who have borrowed all titles written by "Collins."

Please give me some idea.

Thanks for your help!

Tony Received on Fri Sep 27 2002 - 10:35:44 CDT