0
I have the following tables:
id_agendaid_medicdatehour
id_patientpatient name
id_medicdoctor’s name
id_schedulingid_agendaid_patient
I make the following query
select * from tb_agenda as a left join tb_agendamento as b on (a.id_agenda=b.id_agenda)
I would like to return to me the following fields: id_agendamento, hora, nome_medico, nome_ paciente
0
It would be something like this:
SELECT id_agendamento, hora, nome_medico, nome_paciente FROM tb_agenda AS agenda
INNER JOIN tb_agendamento AS agendamento ON agenda.id_agenda = agendamento.id_agenda
INNER JOIN tb_paciente AS paciente ON paciente.id_paciente = agendamento.id_paciente
INNER JOIN tb_medico AS medico ON medico.id_medico = agenda.id_medico
Learn more about how to make a relationship here
There are still some addendums on the structure of their tables. It depends on which business rule you intend to implement, but this way in most cases would be better:
id_agenda:int
date:timestamp
hour:team
id_patient:int
patient name:string
id_medic:int
doctor’s name:string
id_scheduling:int
fk_agenda:int
fk_medic:int
fk_patient:int
Browser other questions tagged sql
You are not signed in. Login or sign up in order to post.
it returns me the name of tb_agenda , but the schedule table only returns me the id I wanted the names . because in tb_scheduling I have key fk id_patient I wanted her to return me with field_patient . when I do left Join
– Sergio Silva
I can’t explain well , but I wanted to display the doctor’s schedules in the schedule table and the patient’s schedule in the schedule table it was viewed in the schedule table grid I use this select * from tb_schedule as a left Join tb_schedule as b on (a. id_agenda=b. id_agenda)
– Sergio Silva
thank you worked!!!! thank you very much I will put hands to work now :)
– Sergio Silva