Please solve a sql query to show data from 3 table.

xwebmaster

Hi

Please help me solving this query..
I have 3 tables..
comm_propDB

Expand|Select|Wrap|Line Numbers

 ID  |  User_ID |   mls_num

-----|---------------|---------------------

2   |     2        |       5004

3   |     2        |       8920

8   |     2        |       5540

5   |     3        |       5263

6   |     3        |       9999

7   |     8        |       1212

comm_propDBElements

Expand|Select|Wrap|Line Numbers

 ID  |   agent_ID |   user_ID

-----|----------------|---------------------

42  |      845    |        3

43  |      845    |        3

44  |      269    |        2

88  |      300    |        2

46  |      124    |        8

47  |      840    |        7

ALL_ALLOWED_AGENT

Expand|Select|Wrap|Line Numbers

 ID     agent_ID  

-----|---------------

1   |    845

2   |    124

I want to write a query that will fetch data from comm_propDB table & comm_propDBElements table if agentID is present in ALL_ALLOWED_AGENT like this :-

Expand|Select|Wrap|Line Numbers

 
ID   agent_ID   User_ID    mls_num

---------------------------------------------------

2       845            2             5004

3       845            2             8920

8       845            2             5540

7       124            2             5004

I have tried everything but couldn`t succeed to solve this query.I also searched on net but didn`t get any perfect solution.
Please suggest the right query.

Thanks a lot.

gaurav1086

hi there.. it seems i have read ur article late.. anyways .. it can be. done..
but first post ur query. and let me have a look at it. i cant post the answer directly according to the rules of this forum. but would love to guide u.
have u tries nested queries?

Please solve a sql query to show data from 3 table.

re: Please solve a sql query to show data from 3 table.

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about