Not getting proper result, please hle

[Anonymous]

Hi Guys,

I have two tables .

TABLE A
CODE	NEED_DATE	A
A	12-Mar-18	2
B	12-Mar-18	1
B	12-Mar-18	3

TABLE B
CODE	DELIVERY_DATE	B
A	02-Mar-18	10
B	07-Jan-18	5
D	18-Jul-18	8

in both tables CODE is the common attribute.

Based on condition where DELIVERY_DATE <= NEED_DATE, I want below result .

NEED_DATE	SUM OF A	SUM OF B
12-Mar-18	6	15

Please help .

Thanks

Sandeep

[sunny_talwar]

May be this

Sum(If(DELIVERY_DATE <= NEED_DATE, A))

Sum(If(DELIVERY_DATE <= NEED_DATE, B))