A.L.E.C wrote:

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;

SELECT * FROM tariffs; http://images21.fotosik.pl/165/c4e82eefa5042592med.jpg

Reszta http://images21.fotosik.pl/165/c7fe36e83f3789b7med.jpg

i tu wydaje sie byc wszystko ok

_______________________________________________ lms mailing list lms@lists.lms.org.pl http://lists.lms.org.pl/mailman/listinfo/lms