Changes between Version 15 and Version 16 of ImportantUseCase3


Ignore:
Timestamp:
12/14/22 21:53:23 (2 years ago)
Author:
201057
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ImportantUseCase3

    v15 v16  
    3030[[Image(03.jpg)]]
    3131{{{#!sql
    32 select adresa, broj
    33 from lokacija l join potrosuvac p
    34 on p.lokacija_id = l.lokacija_id
    35 where lower(p.status) = 'spremna' or lower(p.status) = 'спремна'
     32select adresa, broj from lokacija l
     33join potrosuvac p on p.lokacija_id = l.lokacija_id
     34join naracka n on n.potrosuvac_id = p.korisnik_id
     35where lower(n.status) = 'spremna' or lower(n.status) = 'спремна'
    3636}}}
    3737