Query

[shivom]

I have 3 tables..

1)person --> person_id,last_name,first_name
2)program -->prog_id, prog_name
3)person_advice --> user_id, prog_id

How can i display the particular person name under which he belong to the particular program.
i.e..

Program Name

Person Name
"
"
"

Program Name

Person Name
"
"
"

[leatherback]

Something like

select first_name, last_name from program
left join person_advice on program.prog_id = person_advice.prog_id
left join person on person_id=user_id
where prog_name = '$ThisProgram'