Changes between Version 9 and Version 10 of ImportantUseCase2

Timestamp:

12/26/21 22:43:58 (3 years ago)

Author:

183060

Comment:

--

ImportantUseCase2

@@ -59 +59 @@
         c.ime as Име_Доктор, c.prezime as Презиме_Доктор
 from bolnica as b
-join oddel o on b.bolnica_id = o.bolnica_id 
-join doktor d on (o.bolnica_id, o.oddel_id) = (d.bolnica_id, d.oddel_id) 
+left join oddel o on b.bolnica_id = o.bolnica_id 
+left join doktor d on (o.bolnica_id, o.oddel_id) = (d.bolnica_id, d.oddel_id) 
 join covek c on d.doktor_id = c.covek_id 
 }}}