Changes between Version 8 and Version 9 of ImportantUseCase1

Timestamp:

12/14/22 17:09:23 (2 years ago)

Author:

201065

Comment:

--

ImportantUseCase1

@@ -43 +43 @@
 [[Image(1-05.jpg)]]
 {{{#!sql
-select username, firstname, lastname, locationname  from users u
-join workers w on w.userid=u.userid
-left join locations l on l.locationid=w.locationid
-where u.userid=4
+select articlename, quantity from articles a
+left join storedarticles s on s.articleid=a.articleid 
+where s.locationid=1
 }}}
 *Statement-от погоре е само пример - податоците ќе се земат во однос кој магационер е најавен. \\