Thank you to everyone for the assistance. I'm so sorry if I wasted anyone's time. I certainly appreciate all the effort on this.

told ya i was new at this 🙂

Thanks so much for helping me out on this.

I'm getting a ORA-00905: missing keyword error at CROSS APPLY

Maybe it'd be better if I posted the entire code:

SELECT A.REPORT_DATE, A.REPORT_TYPE, A.ORD_NUM, A.CKT_QTY, A.SUPP_VER, A.ORD_TYPE, A.ORDERPRO_TIN, A.BILLABLE, A.VENDOR, A.E_MRV_FLAG, A.MRV, A.ORDER_EXPEDITE, A.ORDER_EXPEDITE_TYPE, A.PROJECT, A.NASPID, A.CONV_NASPID, A.CUST_NAME, '' AS RYG,...

I guess I'm confused what I would put in the "your table" then..

SELECT RESULTa, BUCKETa

FROM <your table>(???)

Sorry, I think I may not have given you all of the information needed. The datea & dateb are from 2 different table. The query should read like...

Not to sound too stupid, but, huh? 🙂