Skip to Content
0
Apr 09, 2014 at 05:58 AM

Multiplying two columns by CE functions

606 Views

Hi all,

I want to compare performance results between SQL script and CE functions.

I have 2 tables joined and i am multiplying 2 columns by using subquery. Tables are like that;

TABLE: SALES

MATERIALID -------- TOTAL

TABLE: PRICES

MATERIALID -------- UNITP

query is similar like

Select PRICES.MATERIALID, Prices.UNITP * (select sum(TOTAL) from SALES
where PRICES.MATERIALID = SALES.MATERIALID ) as TOTAL_AMOUNT
from PRICES.


is there a way to do it via CE functions ?

Thank you.