Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this
Sum(If(DELIVERY_DATE <= NEED_DATE, A))
Sum(If(DELIVERY_DATE <= NEED_DATE, B))