Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

01/10/24 09:47:00 (10 months ago)

Author:

184006

Comment:

--

AdvancedReports

@@ -25 +25 @@
 WHERE date_askes >= CURRENT_DATE - INTERVAL '6 months';
 }}}
+== Прикажување која терапија за која дијагноза е препишена.
+{{{
+SELECT t.description AS therapy_description,
+       d.description AS diagnosis_description
+FROM project.therapy t
+JOIN project.diagnostics d ON t.diagnosticsID = d.ID;
+}}}