Changes between Version 10 and Version 11 of ImportantUseCase1
- Timestamp:
- 12/14/22 17:55:58 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ImportantUseCase1
v10 v11 43 43 [[Image(1-05.jpg)]] 44 44 {{{#!sql 45 select articlename, quantity from articles a 45 select articlename, quantity from articles a --артикли што се чуваат на дадена локација 46 46 left join storedarticles s on s.articleid=a.articleid 47 47 where s.locationid=1 … … 54 54 {{{#!sql 55 55 select a.articlename, s.quantity, l.locationname, a.description from articles a 56 left join storedarticles s on s.articleid=a.articleid 56 left join storedarticles s on s.articleid=a.articleid --инфо за избраниот артикл 57 57 left join locations l on l.locationid=s.locationid 58 58 where a.articleid=3 … … 61 61 select c.categoryname from categories c 62 62 left join article_belongs_to_category abtc on abtc.categoryid=c.categoryid 63 left join articles a on a.articleid=abtc.articleid 63 left join articles a on a.articleid=abtc.articleid --категории на кои припаѓа артиклот 64 64 where a.articleid=3 65 65 }}}
