FreenetIS

Pridan formular pro pridavani, ale nejde v nem validace. Rozdelano zobrazovani dluzniku, ale dotaz na dluzniky jsem jeste nerozchodil. Kdo ho opravi, ma u me ... treba diplom.

SELECT aid, mid, mname, mstreet, mtown, (
IFNULL , 0 ) - IFNULL
) AS credit
FROM (
SELECT SUM AS outbound, aid, mid, mname, mstreet, mtown
FROM (
SELECT a.id AS aid, m.id AS mid, m.name AS mname, m.street AS mstreet, m.town AS mtown
FROM members m
JOIN accounts a ON a.member_id = m.id
)sel1, money_transfers mt1
WHERE mt1.origin_id = sel1.aid
)sel2, money_transfers mt2
WHERE mt2.destination_id = sel2.aid
AND credit <0
ORDER BY id ASC
LIMIT 0 , 500