Re: array of arrays calculations

[thezip]

in reply to array of arrays calculations

Why not just do the calculation right in the SQL?

select h.cus, 
       h.ta,
       h.gd1 - c.gd1 as diff1,
       h.gd2 - c.gd2 as diff2,
       from hist h, hist c
 where h.cus = c.cus
   and h.ta = c.ta 
 order by h.cus, h.ta

WARNING: not tested! YMMV!

[CountZero]

I didn't try it, but don't you need a "LEFT JOIN" in there somewhere to get the contents of h.cus and h.ta in case c.cus and c.ta don't exist?

[Generoso]

SELECT h.e_id,
    h.cus,
    h.gd1-ifnull(t.gd1,0) as dif1,
    h.gd2-ifnull(t.gd2,0) as dif2
    FROM tabla1 h
      left join tabla2 t on h.e_id = t.e_id and h.cus = t.cus;

This works

[rocky13]

First, i updated the query in the question little bit to simplify the understanding of the question. As you can see, there are multiple rows for each cus, ta, gd1, gd2 and number of rows in one table is not the same as number of rows in other table.Thus, I think it would be best to group them by cus, ta while getting the sum of gd1 and gd2. I thought maybe there is a way with "union all". I did get the solution by using a hash for each and then doing the computation. However, if there is a way to do it just using sql query, I would love to know. Thanks!