Changes between Version 8 and Version 9 of ImportantUseCase000

Timestamp:

12/20/22 15:38:51 (2 years ago)

Author:

181213

Comment:

--

ImportantUseCase000

@@ -33 +33 @@
 {{{#!sql
 -- приказ на сите ресторани
-select restoran_ime, restoran_rejting, restoran_adresa from restoran;
-}}}
-{{{#!sql
--- приказ на броевите на рестораните
-select broj from restoran_tel_broj;
+select r.restoran_ime, r.restoran_rejting, r.restoran_adresa, rtb.broj
+from restoran as r
+join restoran_tel_broj as rtb on r.restoran_id=rtb.restoran_id ;
 }}}