check this... might work..
-
select IEI.sum(cst_Amt), to_char(inside.cst_date,'MM/01/yyyy') from IEI, (Select to_char(cst_date,'MM/01/yyyy') from IEI where cst_typ = 'type2' and cst_date between '01/01/2006' and '06/01/2006' ) inside where cst_typ = 'type1' and proj_no in (select proj_no from IEI where cst_typ = 'type2' and cst_date between '01/01/2006' and '06/01/2006' ) And group by to_char(inside.cst_date,'MM')
-
select IEI.sum(cst_Amt), to_char(inside.cst_date,'MM/01/yyyy') from IEI, (Select to_char(cst_date,'MM/01/yyyy') from IEI where cst_typ = 'type2' and cst_date between '01/01/2006' and '06/01/2006' ) inside where cst_typ = 'type1' and proj_no in (select proj_no from IEI where cst_typ = 'type2' and cst_date between '01/01/2006' and '06/01/2006' ) And group by to_char(inside.cst_date,'MM')
idiot -- modified at 3:54 Wednesday 18th April, 2007 Thanks for the 1 vote, just proves you're an idiot.
Jonathan Wilkes Darka [Xanya.net]