<blink>Our management is looking for a statistics to find out how many patients visited to a doctor for the first time.</blink>
<blink>I have employeemaster , registration and encounter tables</blink>
<blink>In encounter table we have visit date,doctored and registrationid</blink>
<blink>In registration table we have registrationid, registration date</blink>
<blink>In employeemaster we have doctorid, doctorname, joined date<,blink>
<blink>Report 1:The query will be encounterdate range it can be for days,month and year</blink>
<blink>REPORT 2: daily and monthly.<,blink>
<blink>This how I want to display the record</blink>
| doctor name | Total Number of Patient | visited first time of the doctor |
|---|---|---|
| Jhon | 1089 | 56 |
| Tom | 1243 | 87 |
| Jim | 1008 | 33 |
Mathew Roshan is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1