Keyword for Template Document coming from extra table

(sergio samoilovich) #1

I am trying to create new keywords for the Template Documents, and I am getting trouble while inserting my Mysql code in download_template.php…

The code is: SELECT lname, fname, room, bed FROM patient_data, inpatient, bed_occupation, stay WHERE bed_occupation.bedid = inpatient.bedid and = stay.PatientId AND bed_occupation.PatientId =

Does anyone have an answer?