Bialy napisał(a):

Zrzut danych tabeli nodeassignments id nodeid assignmentid 4 1 1 5 2 2 6 3 3

http://images22.fotosik.pl/95/07f279cb0b0fc0c5med.jpg http://images21.fotosik.pl/165/6ca6824f5dc8e91cmed.jpg http://images21.fotosik.pl/165/91629e882e4b2215med.jpg

tutaj wszystko ok, do kompletu podaj jeszcze

SELECT * FROM tariffs; SELECT a.customerid AS id, SUM(uprate) AS uprate, SUM(upceil) AS upceil, SUM(downrate) AS downrate, SUM(downceil) AS downceil

FROM assignments a

LEFT JOIN tariffs ON (a.tariffid = tariffs.id) WHERE EXISTS (SELECT 1 FROM nodeassignments JOIN nodes n ON (n.id = nodeid) WHERE a.id = assignmentid AND n.access = 1) GROUP BY a.customerid;