aperezcrespo wrote on Thursday, August 20, 2009:
Hi
Here is what http://opensourceemr.com:2093/openemr/ returns on a phone list from batchcom.
ERROR: query failed: SELECT DISTINCT patient_data.* , MAX( cal_events.pc_endDate ) AS last_ap, MAX( forms.date) AS last_visit, (DATEDIFF(CURDATE(),patient_data.DOB)/365.25) AS pat_age FROM patient_data, forms LEFT JOIN openemr_postcalendar_events AS cal_events ON patient_data.pid=cal_events.pc_pid LEFT JOIN forms AS forms2 ON patient_data.pid=forms2.pid WHERE patient_data.hipaa_mail=‘YES’ GROUP BY patient_data.pid ORDER BY patient_data.postal_code
Error: Unknown column ‘patient_data.pid’ in ‘on clause’
Thanks