Hello,
i have two table :
(Table 1.) _Dozvole
With fields :
Dozvola_ID
Broj_dozvole
Korisnik_dozvole
Rok_vazenja
Kolicina_u_KG
Naziv_proizvoda
Tarifni_broj_iz_CT
Ostalo_KG
(Table 2.) _Otpisi
With fields :
Otpis_ID
Broj_racuna
Datum_racuna
Spediter
Izvezeno_KG
Broj_dozvole
I WANT TO DISPLAY IN TABLE _Dozvole IN FIELD Ostalo_KG RESULT OF THESE TWO FIELD :
Kolicina_u_KG (table _Dozvole) - TOTAL of colone Izvezeno_KG (table Otpisi) dependent by values from field Broj_dozvole (table:_Otpisi)
THANKS
PHPRUNNER 4.2 368 MySQL