[SQL] pobierz, plaintext 
SELECT visit.date, sfguarduser.first_name, sfguarduser.last_name, patient.first_name, patient.last_name, visit_status.name, service.name, time.name
FROM `visit`
LEFT JOIN `sfguarduser` ON visit.dentist_id = sfguarduser.id
LEFT JOIN `sfguarduser` patient ON visit.patient_id = patient.id
LEFT JOIN `visit_status` ON visit.visit_status_id = visit_status.id
LEFT JOIN `service` ON visit.service_id = service.id
LEFT JOIN `time` ON visit.time_id = time.id
WHERE visit.dentist_id =2;
[SQL] pobierz, plaintext