sql - mysql query - credit debit-> calculate balance (complex tables structure) -

-

i have tables structure:

enter image description here

the "plati" table = credit.

the "suma" column = amount.

sample debit data:

enter image description here

sample credit data:

enter image description here

and want result:

plati.id
debite.iddosar
debite.suma
plati.suma plata
(debite.suma - previous plati.suma order plati.data) restplata

like excel:

enter image description here

is possible sql query not variable, because want split query's create 1 view on finally?


Comments

Post a Comment

Popular posts from this blog

git - Initial Commit: "fatal: could not create leading directories of ..." -

-
i trying make initial commit git repository on github unity project. followed along this guide am. note: reason or another, couldn't set unity's asset serialization mode force text, settled on mixed (which believe should work). when call git clone --bare . , error. note not creator of repository , contributor (though making initial commit). here's in terminal (i'm using git bash): welcome git (version 1.8.4-preview20130916) run 'git git' display index. run 'git <command>' display specific commands. cheddar@cheddar-pc ~ $ cd documents/ics168swarch/ cheddar@cheddar-pc ~/documents/ics168swarch $ git init initialized empty git repository in c:/users/cheddar/documents/ics168swarch/.git / cheddar@cheddar-pc ~/documents/ics168swarch (master) $ git add . warning: lf replaced crlf in assets/prefabs.meta. file have original line endings in working directory. warning: lf replaced crlf in assets/prefabs/pellet.prefab.meta. file have original ...
Read more

parcelable - Unmarshalling unknown type code exception while reading parcel values in Android 4.4+ -

-
i'm using parcelable interface , working fine till android 4.3 (jelly bean) when install same app on device running under android 4.4+ (kitkat) crashing while reading parcel. throwing below error : java.lang.runtimeexception: parcel android.os.parcel@42acce90: unmarshalling unknown type code 6881383 @ offset 1864 when try read : getintent().getextras().getstring("type").contains("some_type"); i have put extra in intent : intent ointent = new intent(getactivity().getapplicationcontext(), eventfragment.class); ointent.putextra("type", "some_type"); after long time , r&d, came know should not use arraylist inside arraylist , within parcelable object. causing issue. so end-up using serializable interface provided java , both concept same.
Read more