Link to home
Start Free TrialLog in
Avatar of DennisHacker
DennisHackerFlag for United States of America

asked on

MySQL Inner Join Logic

Hi.  I have three tables in a MySQL Database.  Let's call them 'doctor', 'meeting_assign', and 'meeting'.  The 'meeting' table has an ID field and information for where the meeting will be held.  The 'doctor' table has information about the doctor.  The 'meeting_assign' table links the doctor to a specific meeting.

I need to formulate a query that gives me a list of the doctors that attend a specific meeting, and I need help with the logic.

Thanks in advance.
ASKER CERTIFIED SOLUTION
Avatar of zephyr_hex (Megan)
zephyr_hex (Megan)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial