sum of a column (development question)

Hi again,

    Development question. User wants the sum of all the purchase orders for this year and last year. I'm trying to get it in the same select statement. I want something like this, but don't know how to get it.

select sum(ord_tot) "TY Invoiced Totals",

       sum(ord_tot) "LY Invoiced Totals" from ar_inv_hdr
where inv_dt between trunc(sysdate, 'YYYY') and sysdate and inv_dt between trunc(sysdate, 'YYYY')-1 and trunc(sysdate, 'YYYY')-365

This, obviously, doesn't do what i want, but it's where i've gotten to so far. Do i need to select from the same table twice?

Thanks,
Lyall

--

We've Got Your Name @ www.mail.com!!!
Get a FREE E-mail Account Today - Choose From 100+ Domains

--

http://www.freelists.org/webpage/oracle-l Received on Tue Sep 11 2007 - 12:32:37 CDT