I have a table named "appointments" and it has a field "patient_id".
And i have "patients" table as well, with all the patient's personal
now i want to display all the appointments for today with patients
Name Phone Email Appointment
ABC 123 email@example.com 01/08/2007 12:30
I have appointments Controller, helper, model but nothing patient so