Help with a complex MYSQL query

[jattsurma]

Hello,

 

I'm having a bit of trouble with trying to figure out what to do. If someone can point me to right direction, it will be greatly appreciated.

 

Here is what I need:

 

I have 2 MYSQL tables in this format:

 

Table userdata: uId, fName, lName, address, account_type, manager_id etc.

Table projects: pId, width, height, pic1, pic2, agent_id etc.

 

What I'm trying to accomplish is:

1) I want to get all the agents (account_type from userdata table) from 1 manager using the manager_id.

2) Show all the projects posted by all the agents under this manager.

 

Can someone tell me how can this be done using php and MYSQL.

 

Thanks in advance for your suggestions and help!

 

Jatt Surma

[ignace]

1) SELECT account_type FROM userdata WHERE manager_id = $managerID

2) SELECT projects.* FROM projects JOIN userdata ON projects.agent_id = userdata.account_type WHERE manager_id = $managerID

 

Do the above queries give you what you need?

[jattsurma]

Hello Ignace,

 

Thanks for your help! Your second query was all I needed. I changed the userdata.account_type to userdata.account_id and it worked like a charm.

 

Thanks again! I appreciate it. I really gotta learn how to join tables.

 

Jatt Surma