Ygthkb

Does Windows 10's telemetry include sending *.doc files if Word crashed?

What is better: yes / no radio, or simple checkbox?

How would a Dictatorship make a country more successful?

Explain the objections to these measures against human trafficking

How to explain planetary rings pulsating?

Disable the ">" operator in Rstudio linux terminal

What flying insects could re-enter the Earth's atmosphere from space without burning up?

Notes in a lick that don't fit in the scale associated with the chord

Can a dragon be stuck looking like a human?

Why does a metal block make a shrill sound but not a wooden block upon hammering?

Avoiding morning and evening handshakes

Checking for the existence of multiple directories

What to do when being responsible for data protection in your lab, yet advice is ignored?

If I sold a PS4 game I owned the disc for, can I reinstall it digitally?

Program that converts a number to a letter of the alphabet

How would one buy a used TIE Fighter or X-Wing?

How to acknowledge an embarrassing job interview, now that I work directly with the interviewer?

Why zero tolerance on nudity in space?

Chess tournament winning streaks

Why did the villain in the first Men in Black movie care about Earth's Cockroaches?

Is it a fallacy if someone claims they need an explanation for every word of your argument to the point where they don't understand common terms?

If I delete my router's history can my ISP still provide it to my parents?

Jumping Numbers

It took me a lot of time to make this, pls like. (YouTube Comments #1)

how to insert a value to sql database by summing last row value and the inserting value

Limit WHERE to MAX() & COUNT()MySQL optimization - year column grouping - using temporary table, filesortMySQL InnoDB logfiles resized - review mysql-err.log for potential problemsERROR 1166 (42000) at line 65203: Incorrect column name ''How to subtract fields and insert the value in other field automatically?mysql - query records to fetch by time stampMySQL : Avoid Temporary/Filesort Caused by GROUP BY Clause in ViewsKeeping an updated balance (Accounting)how to merge two or more tables sorted according to dateHandle 4 tables and to show 4 columns as result

0

i have two table

credit table

id date credit
1 4-1-2019 300
2 10-1-2019 500
3 10-2-2019 300

debit table

id date debit
1 2-1-2019 400
2 6-1-2019 600
3 2-2-2019 300

I want to join both table order by date and sum balance from credit and debit

just like this

somthng like this


id date debit credit balance
1 2-1-2019 400 400
1 4-1-2019 300 100
2 6-1-2019 600 700
2 10-1-2019 500 200
3 2-2-2019 300 500
3 10-2-2019 300 200

iam using this got so far

select id, dates, debit, credit, (COALESCE(debit, 0) - COALESCE(credit, 0)) as balance
from ( (select id, dates, debit, null as credit from debit)
union all
(select id, dates, null as debit, credit from credit)
) b
order by dates

but the balance column is not summing with the last balance column value

my output is

`

id date debit credit balance
1 2-1-2019 400 400
1 4-1-2019 300 -300
2 6-1-2019 600 600
2 10-1-2019 500 -500
3 2-2-2019 300 300
3 10-2-2019 300 -300

as u can see balance column not summing up as my requirement. iam not expert so I welcome any new method also

mysql php phpmyadmin

share

asked 5 mins ago

Sharoon CkSharoon Ck

11

New contributor

Sharoon Ck is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

i have two table

credit table

id date credit
1 4-1-2019 300
2 10-1-2019 500
3 10-2-2019 300

debit table

id date debit
1 2-1-2019 400
2 6-1-2019 600
3 2-2-2019 300

I want to join both table order by date and sum balance from credit and debit

just like this

somthng like this


id date debit credit balance
1 2-1-2019 400 400
1 4-1-2019 300 100
2 6-1-2019 600 700
2 10-1-2019 500 200
3 2-2-2019 300 500
3 10-2-2019 300 200

iam using this got so far

select id, dates, debit, credit, (COALESCE(debit, 0) - COALESCE(credit, 0)) as balance
from ( (select id, dates, debit, null as credit from debit)
union all
(select id, dates, null as debit, credit from credit)
) b
order by dates

but the balance column is not summing with the last balance column value

my output is

`

id date debit credit balance
1 2-1-2019 400 400
1 4-1-2019 300 -300
2 6-1-2019 600 600
2 10-1-2019 500 -500
3 2-2-2019 300 300
3 10-2-2019 300 -300

as u can see balance column not summing up as my requirement. iam not expert so I welcome any new method also

mysql php phpmyadmin

share

asked 5 mins ago

Sharoon CkSharoon Ck

11

New contributor

Sharoon Ck is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

i have two table

credit table

id date credit
1 4-1-2019 300
2 10-1-2019 500
3 10-2-2019 300

debit table

id date debit
1 2-1-2019 400
2 6-1-2019 600
3 2-2-2019 300

I want to join both table order by date and sum balance from credit and debit

just like this

somthng like this


id date debit credit balance
1 2-1-2019 400 400
1 4-1-2019 300 100
2 6-1-2019 600 700
2 10-1-2019 500 200
3 2-2-2019 300 500
3 10-2-2019 300 200

iam using this got so far

select id, dates, debit, credit, (COALESCE(debit, 0) - COALESCE(credit, 0)) as balance
from ( (select id, dates, debit, null as credit from debit)
union all
(select id, dates, null as debit, credit from credit)
) b
order by dates

but the balance column is not summing with the last balance column value

my output is

`

id date debit credit balance
1 2-1-2019 400 400
1 4-1-2019 300 -300
2 6-1-2019 600 600
2 10-1-2019 500 -500
3 2-2-2019 300 300
3 10-2-2019 300 -300

as u can see balance column not summing up as my requirement. iam not expert so I welcome any new method also

mysql php phpmyadmin

share

asked 5 mins ago

Sharoon CkSharoon Ck

11

New contributor

Sharoon Ck is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

Sharoon CkSharoon Ck

11

New contributor

Sharoon Ck is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 5 mins ago

Sharoon CkSharoon Ck

11

New contributor

Sharoon Ck is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Sharoon CkSharoon Ck

11

New contributor

Sharoon Ck is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 5 mins ago

Sharoon CkSharoon Ck

11