Changes between Version 10 and Version 11 of ImportantUsecase2

Timestamp:

01/10/22 18:58:31 (3 years ago)

Author:

193270

Comment:

--

ImportantUsecase2

@@ -40 +40 @@
 
 {{{
-select * from knigi as kn
+select kn.naslov, kn.opis 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
@@ -47 +47 @@
 
 {{{
-select * from knigi
+select kn.naslov, kn.opis from knigi
 where naslov = 'Мојот маж';
 }}}
 
 {{{
-select * from knigi as kn
+select kn.naslov, kn.opis from knigi as kn
 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