Tabela korisnici
Code:
id | korisnik
---------------------------
1 | pero
2 | simo
3 | jovan
4 | milan
id | korisnik
---------------------------
1 | pero
2 | simo
3 | jovan
4 | milan
Tabela uplate
Code:
korisnik | iznos
----------------------------
simo | 25
jovan | 40
korisnik | iznos
----------------------------
simo | 25
jovan | 40
Tabela racuni
Code:
korisnik | jed_cijena | kolicina
------------------------------------------------
simo | 1 | 25
simo | 3 | 2
pero | 2 | 2
korisnik | jed_cijena | kolicina
------------------------------------------------
simo | 1 | 25
simo | 3 | 2
pero | 2 | 2
Pokusavam da dobijem sljedece
Code:
id | korisnik | suma racuna | suma uplata
------------------------------------
1 | pero | 4 | 0
2 | simo | 31 | 25
3 | jovan | 0 | 40
4 | milan | 0 | 0
id | korisnik | suma racuna | suma uplata
------------------------------------
1 | pero | 4 | 0
2 | simo | 31 | 25
3 | jovan | 0 | 40
4 | milan | 0 | 0
Stao mi mozak sada pa ako moze mala pomoc. :)