UPDATE #Request.prefix_db_agency#.pMed_Interaction_Report r INNER JOIN #Request.prefix_db_agency#.Communication c ON c.Comm_ID = r.Comm_ID AND IFNULL(c.send_fax, 0) = 1 AND IFNULL(c.Status, 0) = 0 SET r.Status = 0, r.Reported_Date = IFNULL(DATE(c.fax_sent_date), CURDATE()), r.Reported_By = IF(IFNULL(r.Reported_By, 0) = 0, , r.Reported_By), r.Reporting_Method = IF(TRIM(IFNULL(r.Reporting_Method, '')) = '', 'Fax', r.Reporting_Method) WHERE r.Status = 2 AND IFNULL(r.Comm_ID, 0) > 0 AND r.Patient_ID = SELECT pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pPtmeds.PtMeds_ID, pPtmeds.Drug_Name, LCASE(TRIM(Meds_New.Generic_Name)) AS Generic, IFNULL(phys.Phys_Last, '') AS Phys_Last, IFNULL(phys.Phys_First, '') AS Phys_First FROM #Request.prefix_db_agency#.pPatients INNER JOIN #Request.prefix_db_agency#.pPtmeds ON pPtmeds.Patient_ID = pPatients.Patient_ID AND pPtmeds.Status = 0 INNER JOIN #Request.prefix_db_lookup#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_Num AND TRIM(IFNULL(Meds_New.Generic_Name, '')) <> '' LEFT JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID AND pAdmit.Status = 0 AND pAdmit.Admit_ID = ( SELECT MAX(a2.Admit_ID) FROM #Request.prefix_db_agency#.pAdmit a2 WHERE a2.Patient_ID = pPatients.Patient_ID AND a2.Status = 0 ) LEFT JOIN #Request.prefix_db_lookup#.pPhysicians phys ON phys.Phys_ID = pAdmit.Render_Phys_ID AND phys.Status = 0 WHERE pPatients.Status = 0 AND pPatients.Patient_ID = ORDER BY pPatients.Pt_Last, pPatients.Pt_First, pPatients.Patient_ID, pPtmeds.PtMeds_ID SELECT Report_ID, Patient_ID, Fingerprint, Comm_ID, Status, IFNULL(Reported_Date, NULL) AS Reported_Date, IFNULL(Reported_By, 0) AS Reported_By, IFNULL(Reporting_Method, '') AS Reporting_Method FROM #Request.prefix_db_agency#.pMed_Interaction_Report WHERE Status IN (0, 2) AND Patient_ID = SELECT DISTINCT LCASE(TRIM(drug_generic)) AS Drug_Generic FROM hhapowerpath.Med_Interactions WHERE TRIM(IFNULL(drug_generic, '')) <> '' SELECT DISTINCT LCASE(TRIM(drug_generic)) AS Drug_Generic, LCASE(TRIM(interaction_generic)) AS Interaction_Key, interaction_generic AS Interaction_Generic, IFNULL(level, '') AS Interaction_Level, IFNULL(notes, '') AS Med_Interaction_Notes FROM hhapowerpath.Med_Interactions WHERE LCASE(TRIM(drug_generic)) IN ( ) AND TRIM(IFNULL(interaction_generic, '')) <> '' " & HTMLEditFormat(_p.Med1_Name) & " ↔ " & HTMLEditFormat(_p.Med2_Name) & "" & HTMLEditFormat(_lvlBit) & HTMLEditFormat(_noteBit) & "">