You probably could do this in one pass as Naomi is suggesting, but chances are it's much faster to do it in the two statements as you have it.

>The following two SQL statements are giving me the correct record set. My question is there a way I can do this with one statement? Is there a better way to do this?
>
>
>

>SELECT item, descrip, extprice, invdte, YEAR(invdte) as invyear FROM artran99 UNION ALL select item, descrip, extprice, invdte, YEAR(invdte) as invyear FROM arytrn99 ORDER BY item INTO TABLE invdata
>
>
>SELECT item, descrip, SUM(IIF(invyear = YEAR(DATE()),extprice,0)) as CurrentYear, SUM(IIF(invyear = YEAR(DATE())-1,extprice,0)) as OneYearAgo, SUM(IIF(invyear = YEAR(DATE())-2,extprice,0)) as TwoYearsAgo, SUM(extprice) as YTDTotal FROM invdata GROUP BY item,descrip
>