3 Replies Latest reply on Apr 22, 2012 7:22 PM by Jonathan Drummey

    Adding up the value from two different data sources..?

      Hello all,

      Here goes my query..!

       

      I want to add data from two different tables.

      One table stores the data in cumulative form from that table I want to select data for the last day in my database(as data is cumulative)

      In the second table data is stored on daily basis i.e its incremental , for this I need to aggregate the data upto the last date.

       

      Finally, I want the sum of this two data.

       

      I am able to get these two counts separately but I am not able to add them up.

      As both of them are totally different.

      Kindly help me out.