How to do the query over two tables

cy163 · #1 (**permalink**) 10-15-08, 23:09

Hello ALL,

I would like to get a list of persons who ever borrowed book more than once in a month by querying the following two tables.

tb1

Code:

Name   Class
Bob     A
John    B
Mary   B
Winston C
Lee     C

tb2

Code:

Name  Month  BorrowedBookName
Bob    Jan         bookname1
Bob    Jan         bookname2
Mary  Feb         bookname3
Mary  Feb         bookname4
Mary  Feb         bookname5
Winston Mar      bookname6
John   Aug.       bookname7
John   Aug.       bookname8

Thanks

r937 · #2 (**permalink**) 10-15-08, 23:21

Code:

SELECT DISTINCT name
  FROM (
       SELECT name
            , month
         FROM tb2
       GROUP
           BY name
            , month
       HAVING COUNT(*) > 1
       ) AS d

Internet Services

Web Development

Digital Marketing

Consumer Tech