MySQL query for a many to many relation.

See more:

PHP

MySQL

I have three tables

Branch in user_branch is basically locations supposedly A,B,C
Account type in user_acct_type is account type may be D,E,F,G,H

user_branch

----------------------------------
Sr-no   |   Username  |  Branch  |
----------------------------------
1       |   User 1    |  A       |
2       |   User 1    |  B       |
3       |   User 2    |  A       |
4       |   User 2    |  C       |
---------------------------------|

user_acct_type

-----------------------------------
Sr-no   |   Username  |  Acct_type |
-----------------------------------
1       |   User 1    |  D         |
2       |   User 1    |  E         |
3       |   User 2    |  F         |
4       |   User 2    |  G         |
-----------------------------------|

cust_code

---------------------------------------------------------------------------
Sr-no   |   Customer Name  |  Customer Code |  Branch   |  Account Type   |
---------------------------------------------------------------------------
1       |   Customer 1     |  1234          |  A        |    D            |
2       |   Customer 2     |  1235          |  C        |    F            |
3       |   Customer 3     |  1236          |  B        |    G            |
4       |   Customer 4     |  1237          |  A        |    H            |
--------------------------------------------------------------------------|

Basically my requirement is that User 1 should be able to search for only those customers names whose branch is A or B(as specified in the table user_branch) and at the same time only those customer names whose account type is D or E(as specified in user_acct_type). I am not able to qrite any query such that all the conditions are satisfied in a single query. Any help is appreciated. Thanks


Edit I tried the query

select c.Cust_Name as Customer
from custcode c
inner join user_branch b on c.branch = b.branch
inner join user_acctype a on c.Cust_typeofaccount  = a.acctype
order by c.Cust_Name

Now my question is how do I filter out the results based on user session?