How to build a SQL query correctly?

Question

MySQL

Good evening, there is such a database. (Polyclinic database)
You need to make a request to select the patient's first and last name by doctor's name
and by referral number.
The first and last name are in the USER table, the IDs that link PATIEN and DOCTOR are in the APPOINTMENT.
Questions:
How can I link 3 tables?
Do you need to build on request?
Is it possible to fit all this into 1 SELECT ?

Answer 1

You can fit in 1 SELECT. A few JOINs will help you out. Train. Try joining Appointment to Patient first, then Users and Doctors. Good luck