SQL Query

From: <diedrik_at_akvavsk.nu>
Date: Wed, 16 Mar 2005 22:47:57 GMT
Message-ID: <xI2_d.19818$d5.149670@newsb.telia.net>

Hi All

I need some help.
I have a table with 2 fields (Nights and year )that looks like this: Nights, Year

        1, 2004
        2, 2004

44, 2005
45, 2005

Now I want to make an sql query that returns a sum of each year like this:

field 2004,2005
Data 3, 89

How can I make this work?

Sincerely
Diedrik Received on Wed Mar 16 2005 - 16:47:57 CST