Re: MySQL Query for balance (credit / debit) beetween shop

Alessandro Arici wrote:

> […]
> I hope that you can help me to solve my problem...
>
> Let's say we have this table:
> […]
> So, my final sheet / table need to be:
>
> id_account 1 in debit of 3 EURO id_account 2 in credit of 3 EURO.
>
> It is not important that first shop has "gained" 7 EURO (10 EURO charged -
> 3 EURO in debit with shop 2).
>
> I hope that it's clear.

[sic]

Yes, it is clear that you want others to do your homework.

<www.catb.org/~esr/faqs/smart-questions.html>

> Thank you guys

You are welcome.

-- 
PointedEars

Twitter: _at_PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.