Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
let's say I have
Order:
load
id_order,
date_order,
id_client
from [qvd\order.qvd] (qvd);
lineOrder:
load
id_order,
id_line_order,
ammount_line
from [qvd\orderline.qvd] (qvd);
I need the total ammount calculated on the Order table.
How can I get this?
I want the Order table to be
Order:
load
id_order,
Date_order,
id_client,
total_ammount_order
from [qvd\order.qvd] (qvd);
Thanks to all
Hi,
Orders:
load
id_order,
date_order,
id_client
from [qvd\order.qvd] (qvd);
left join (Orders)
load
id_order,
id_line_order,
ammount_line
from [qvd\order.qvd] (qvd);
left join (Orders)
load
id_order,
sum(ammount_line) as sumorder
resident Orders
group by id_order;
Regards
hi,
I want to keep separated the Order and the Orderline table,
the code you suggest does the left join...
Instead ....
left join (Orders)
load
id_order,
sum(ammount_line) as sumorder
resident Orders
group by id_order;
return me and error as invalid statement!!