I've got payments table for estate agency and I want display Properties and total ammount was payed for each property
SELECT PROPERTYID, PROPERTYNAME, TENANT, SUM(PAYMENTAMOUNT) FROM PAYMENTS GROUP BY PROPERTYID;
and it doesn't work.
How can I do it?

You need to add ALL aggregated columns to the GROUP BY:

Code:

SELECT PROPERTYID, PROPERTYNAME, TENANT, SUM(PAYMENTAMOUNT)
  FROM PAYMENTS
 GROUP BY PROPERTYID, PROPERTYNAME, TENANT;

SELECT PROPERTYID, PROPERTYNAME, TENANT, SUM(PAYMENTAMOUNT) FROM PAYMENTS GROUP BY PROPERTYID,PROPERTYNAME,TENANT;

All colums must be in group by clause
Or
select a.propertyid, propertyname, tenant from payments b, (a.totalselect propertyid, sum(paymentamount) total from payments a group by propertyid)
where a.propertyid=b.propertyid

Hope this help you

what does a.totalselect means?

But I want it to be grouped by propertyID only and in the same time see other fields.

Try this:

Code:

SELECT P.PROPERTYID, P.PROPERTYNAME, P.TENANT, T.TOTAMT
  FROM PAYMENTS P
     , (SELECT PROPERTYID, SUM(PAYMENTAMOUNT) TOTAMT
          FROM PAYMENTS
         GROUP BY PROPERTYID) T
 WHERE P.PROPERTYID = T.PROPERTYID;