Changes between Version 4 and Version 5 of ImportantUseCase3

Timestamp:

12/21/22 14:34:30 (18 months ago)

Author:

201070

Comment:

--

ImportantUseCase3

@@ -14 +14 @@
 {{{
 -- приказ на сите категории
-select categoryname from categories as c 
+select c.categoryname from project.categories as c 
 }}}
 
@@ -22 +22 @@
 Клиентот избира категорија.
 
+
 [[Image(picture2.png)]]
+
+{{{
+  select c.categoryid from project.categories as c
+  where c.categoryid = selectedCategoryId
+}}}
 
 === Чекор 3
@@ -31 +37 @@
 [[Image(picture5.png)]]
 
+{{{
+--приказ на продукти од категорија
+   select p.productname  from project.products as p
+   where p.categoryid = selectedCategoryId
+}}}
 
+
+{{{
+--избор на продукт
+   select p.productname from project.products as p
+   where p.productid  = selectedProductId
+}}}
 === Чекор 4
 
@@ -40 +57 @@
 {{{
 -- приказ на избран продукт
-select productid, productname, postdate, manufacturerid, categoryid, characteristcid from products as p   
+select p.productname, m.manufacturername, c.categoryname 
+from project.products as p
+        inner join project.manufacturers as m on (m.manufacturerid = p.manufacturerid)
+        inner join project.categories as c on (c.categoryid = p.categoryid)
 }}}