quote:

---

Originally posted by bjoerns

or c.trans_code in ('15')

---

select		c.box,
		sum(c.trans_amt) as amt,
		c.trans_code,
		max(c.dln) as dln,
		c.process_date,
		c.tc_code
from		dba.ctopenmo as c
inner join	(
			select		box,
					max(process_date) as Proc_dt,
					trans_amt
			from		dba.ctopenmo
			where		trans_code = '08'
					and tc_code = '01'
					and trans_amt > 0
			group by	box,
					trans_amt
		) as d on d.box = c.box
			and c.process_date = d.proc_dt 
where		c.trans_code is null
		or c.trans_code in ('01', '15')
		and c.method_code not in ('3', '4')
		and c.tc_code not in ('06', '19')
		and c.process_date >= '2008-08-14'
group by	c.box,
		c.trans_code,
		c.process_date,
		c.tc_code