Changes between Version 16 and Version 17 of ImportantUseCase2

Timestamp:

01/20/22 13:19:04 (3 years ago)

Author:

183060

Comment:

--

ImportantUseCase2

@@ -35 +35 @@
         c.embg as Матичен_број, u.dijagnoza as Дијагноза
 from upat as u
-join pacient p on u.pacient_id = p.pacient_id 
-join covek c on p.pacient_id = c.covek_id 
-where u.upat_id = 'selected_upat_id'; -- вредноста се однесува на ИД-то на избраниот упат
+join pacient p on u.covek_pacient_id = p.covek_pacient_id 
+join covek c on p.covek_pacient_id = c.covek_id 
+where u.upat_id = 3 ; -- вредноста за упат е дадена само за пример
 }}}
 
@@ -77 +77 @@
 {{{#!sql
 select b.naziv as Болница, b.grad as Град, o.naziv as Оддел,
-        c.ime as Доктор_Име, c.prezime as Доктор_Презиме, d.doktor_id as Доктор_ИД
+        c.ime as Доктор_Име, c.prezime as Доктор_Презиме, d.doktor_id as Доктор_ИД
 from bolnica as b
 left join oddel o on b.bolnica_id = o.bolnica_id