Changes between Version 15 and Version 16 of ImportantUsecase2

Timestamp:

01/12/22 17:31:26 (3 years ago)

Author:

193270

Comment:

--

ImportantUsecase2

@@ -17 +17 @@
 
 {{{
-select naslov, opis from knigi;
+select kn.naslov, kn.opis, a.ime, k.ime_kategorija from knigi as kn
+join izdava as i on i.id_knigi=kn.id_na_kniga
+join avtor as a on a.id_na_avtor=i.id_avtor
+join e_od as e on e.id_knigi=kn.id_na_kniga
+join kategorija as k on k.id_na_kategorija=e.id_na_kategorija
 }}}