Re: [lms] sql customerlist tarrifvalue i balance

Moze to zadziala ;) Dopisalem z palca tylko SUM, nie sprawdzale co to daje.

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) ORDER BY lastname;

!DSPAM:486167b1139241859716918!