- Increase transparency
- Onboard new hires faster
- Access from mobile/offline
select sum(T69330.STOCK_QTY) as c1, T13269.COMP_DIV as c2, T13269.STY_RET_TYPE as c3 from DW_TIME T14149 ,DW_PRODUCTS T13269 ,DW_DAILY_STOCK_AND_MSS T69330 where ( T13269.PKID = T69330.PRODUCT_ID and T13269.COMP_DIV = 'CARAVANNING' and T14149.CAL_DATE = TO_DATE('2012-03-19' , 'YYYY-MM-DD') and T14149.PKID = T69330.TIME_ID ) group by T13269.COMP_DIV, T13269.STY_RET_TYPE
select sum(a.STOCK_QTY) as c1, p.COMP_DIV as c2 , p.STY_RET_TYPE as c3 from dw_daily_stock_and_mss a, dw_time t, dw_products p where ( p.pkid = a.product_id and p.COMP_DIV = 'CARAVANNING' and T.CAL_DATE = TO_DATE('2012-03-19' , 'YYYY-MM-DD') and t.pkid = a.time_id ) group by p.COMP_DIV , p.STY_RET_TYPE
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!