Re: [lms] sql customerlist tarrifvalue i balance

daje w wyniku jeden rekord z klientem o pierwszym id a w cash suma dla wszystkich klientow

A może tak:

SELECT customers.id, customers.lastname, customers.name, customers.address, customercontacts.phone, SUM( cash.value ) FROM customers LEFT JOIN customercontacts ON ( customers.id = customercontacts.id ) JOIN cash ON ( customers.id = cash.customerid ) GROUP BY customers.id