🚀 go-pugleaf

Maxim Shiryaev wrote:
> Hi.
>
> I think you need a SP here.
>
> for
>   select date
>     from purchase
>
>     union all
>
>     select date
>     from sales
>
>     group by 1
>   into :d
>   /* now you have all the dates here */
> do begin
>
>   select sum(purchase_line.qty), sum(purchase_line.price *
> purchase_line.qty),
>   from purchase
>     left join purchase_line on purchase_line.purchase_id =
> purchase.purchase_id
>   where
>     purchase.date = :d
>   into :purchase_qty, :purchase_amount;
>
>   select sum(sales_line.qty), sum(sales_line.price * sales_line.qty)
>   from sales
>     left join sales_line on purchase_line.sales_id = sales.sales_id
>   where
>     sales.date = :d
>   into :sales_qty, :sales_amount;
>
>   /* be prepared to deal with NULLs in qty and amount here */
>
>   /* calculate whatever needed */
>
> end
>
> And I would even combine both purchases and sales into single table with one
> additional field like SIGN with +1 | -1 values to differentioate between two
> types of operations. So you can create an index on date and get fast GROUP
> BY speed. If so you could make the result in one pass ordering by dates and
> summing appropiate variable depending on sign.
>
>
> Maxim.
>
>
>
>   
>
>
>   
Thanks , but I did not understand how I can make the sign field