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.