| 1 | drop view if exists produkti_cena;
|
|---|
| 2 |
|
|---|
| 3 | create view produkti_cena as
|
|---|
| 4 |
|
|---|
| 5 | select p.ime, p.kolicina, m.lokacija, c.iznos
|
|---|
| 6 | from proizvodi as p
|
|---|
| 7 | left join parce as pr on pr.id_proizvod=p.id_proizvod
|
|---|
| 8 | left join parce_dostapno_vo_magacini as pdm on pr.id_parce=pdm.id_parce
|
|---|
| 9 | left join magacini as m on pdm.id_magacin=pdm.id_magacin
|
|---|
| 10 | left join cena as c on c.id_proizvod=p.id_proizvod
|
|---|
| 11 |
|
|---|
| 12 | group by 1, 2, 3, 4;
|
|---|
| 13 |
|
|---|
| 14 | select pc.ime, pc.kolicina, pc.lokacija, pc.iznos as najniska_cena
|
|---|
| 15 | from produkti_cena as pc
|
|---|
| 16 | where pc.iznos = (select min(iznos) from produkti_cena) |
|---|
