On Sat, 13 Sep 2003, Łukasz Jarosław Mozer wrote:

SELECT users.id AS id, SUM((type * 2 - 7) * value) AS balance FROM users LEFT JOIN cash ON users.id = cash.userid AND (cash.type = 3 OR cash.type = 4) GROUP BY users.id

dzieki Ci wielkie za to.... gdybys tylko napisal mi gdzie mam dodac *where users.status = 3* bo ni w 5.. ni w 10.. mi nie pasuje....

Pozdrawiam Pawel Bernadowski GG 3377, email kontakt@pbern.biz