sql optimize search many-many
    usertable
    ----
    id, username
    
    grouptable
    ----
    id, groupname
    
    group_user
    --------
    uid, gid
    
    books
    ----
    id, groupname


Input parameters:  groupname, username   
output:  list of books 

Is it possible to use 1 sql statement to get list of books when username is inside groupname



Question 2:  any good book to recommand to master complex sql statement..

sql optimize search many-many
===

    usertable
    ----
    id, username
    
    grouptable
    ----
    id, groupname
    
    group_user
    --------
    uid, gid
    
    books
    ----
    id, groupname


Input parameters:  groupname, username   
output:  list of books 

Is it possible to use 1 sql statement to get list of books when username is inside groupname



Question 2:  any good book to recommand to master complex sql statement..
