Summarize Table Info

Problem:

I have a detail dollar table with dates. I need to create a table summarizing the last 3 calendar years by calendar year.

Input:

idnumber
giftamount
giftdate

Desired Output:

idnumber

cy1996_amount
cy1995_amount
cy1994_amount

	select
		dollar.idnumber, 
		sum(dollar.amount) "CY1996"
	from
		master,
		dollar
	where


		(master.idnumber = dollar.idnumber)	and


		((dollar.date >= '01-jan-96')		and


		 (dollar.date <= '31-dec-96'))
	group by
		dollar.idnumber

How can I get the other two calendar years to work?

Thanks in advance for any and all HELP - Dave. Received on Fri Nov 15 1996 - 00:00:00 CET