fetch_onto_scale_on_criteria

-- fetch_onto_scale_on_criteria
-- MS ACCESS JET
-- items table: id, t (process time), v (value), prop (property)
-- scale view: n (interval number on chart time axis), a (from), b (upto)
SELECT scale.n,
       scale.a,
       scale.b,
       r0.v0,
       rA.vA,
       rB.vB,
       rC.vC
FROM
(((scale
        LEFT JOIN
     (SELECT n,
             SUM(v) AS v0
      FROM
        (SELECT items.v,
                scale.n
         FROM items,
              scale
         WHERE items.t>=scale.a
           AND items.t<scale.b)
      GROUP BY n) AS r0 ON scale.n=r0.n)
  LEFT JOIN
    (SELECT n,
            SUM(v) AS vA
     FROM
       (SELECT items.v,
               scale.n
        FROM items,
             scale
        WHERE items.t>=scale.a
          AND items.t<scale.b
          AND items.prop='a')
     GROUP BY n) AS rA ON scale.n=rA.n)
 LEFT JOIN
   (SELECT n,
           SUM(v) AS vB
    FROM
      (SELECT items.v,
              scale.n
       FROM items,
            scale
       WHERE items.t>=scale.a
         AND items.t<scale.b
         AND items.prop='b')
    GROUP BY n) AS rB ON scale.n=rB.n)
LEFT JOIN
  (SELECT n,
          SUM(v) AS vC
   FROM
     (SELECT items.v,
             scale.n
      FROM items,
           scale
      WHERE items.t>=scale.a
        AND items.t<scale.b
        AND items.prop='c')
   GROUP BY n) AS rC ON scale.n=rC.n;