SQL Select

I have a little problem with a select statement. I want to be able to put all these selects into only one select. Is someone can tell me the good syntax please?

SELECT PT06.NO_DOSS_IR as doss1, sum(PT06.MNT_IMPUT) AS Total1995 FROM PT06
WHERE PT06.DAT_EVEN_ORIG_IR='1995'
GROUP BY PT06.NO_DOSS_IR SELECT PT06.NO_DOSS_IR as doss2, sum(PT06.MNT_IMPUT) AS Total1996 FROM PT06
WHERE PT06.DAT_EVEN_ORIG_IR='1996'
GROUP BY PT06.NO_DOSS_IR SELECT PT06.NO_DOSS_IR as doss3, sum(PT06.MNT_IMPUT) AS Total1997 FROM PT06
WHERE PT06.DAT_EVEN_ORIG_IR='1997'
GROUP BY PT06.NO_DOSS_IR; The final result must be like this:

DOSS1 DOSS2 DOSS3 TOTAL1995 TOTAL1996 TOTAL1997

The order of the columns is not important. But it is very important that I have all these columns into one result

Thank you
Alain Gagne
Alain.Gagne_at_cgi.ca
Alain Gagne
CGI inc. Received on Tue Jul 15 1997 - 00:00:00 CDT