Need some help from the pros...please

[stackumhi]

I have 3 tables and need to pull info from each.

 

Members

- member_id

- first_name

- last_name

- agdnumber

 

Evaluations

- eval_id

- credit_hours

- course_title

 

Evals_completed

- member_id

- eval_id

 

I need to create a list of all the members and the evals that they have taken but only show members that have an entry in the column 'agdnumber' from the members table.

 

 

Example of list needed:

 

Dr. John Smith (from members)

12345 (agdnumber from members)

Advances in Soft Tissue Grafting for Implants - 1.5 credit hours (from evaluations)

Going Green in Dentistry - 3 credit hours (from evaluations)

 

Dr. Sam Morgan

12345 (agd number)

Advances in Soft Tissue Grafting for Implants - 1.5 credit hours (from evaluations)

Going Green in Dentistry - 3 credit hours (from evaluations)

 

Thank you for any advise.

 

[Maq]

So do you have a question?

 

(Please be conscious of where you post this is clearly a SQL issue, not PHP Coding)

[betterphp]

you would have to use two JOINs

 

somethign like this.

 

SELECT
`members`.`firstname`,
`members`.`lastname`,
`members`.`agdnumber`,
`evaluations`.`cource_title`,
`evaluations`.`credit_hours`
FROM `members`
INNER JOIN `evals_completed`
ON `members`.`member_id` = `evals_completed`.`member_id`
INNER JOIN `evaluations`
ON `evals_completed`.`eval_id` = `evaluations`.`eval_id`

 

untested (because I don’t have that database) but it should work

[ignace]

http://dev.mysql.com/doc/refman/5.0/en/join.html

 

This isn't rocket-surgery:

 

SELECT e.credit_hours, e.course_title, ec.agdnumber, ec.first_name, ec.last_name
FROM evals_completed ec
JOIN evaluations e USING(eval_id)
JOIN members m USING(member_id)
WHERE ec.agdnumber IS NOT NULL

[betterphp]

double post with http://www.phpfreaks.com/forums/index.php?topic=328883.0

[Maq]

double post with http://www.phpfreaks.com/forums/index.php?topic=328883.0

Yes.

@stackumhi - Do not post more than once.  You actually triple posted the same exact question.  I merged the replies from the other thread here.

[stackumhi]

Sorry for over posting and posting in the wrong location.

 

Thank you for your help.