Hi All
Is the following possible in just one select? I have the following table:

Country  CarGroup  MinDays  Rate
   US        A        1      20
   US        A        7      18
   US        B        1      25
   US        B        7      22
   FR        A        3      21
   FR        A        7      19

I would like for the above example to obtain the following:

Country  CarGroup  Rate1  Rate3  Rate7
   US        A       20     0      18
   US        B       25     0      22
   FR        A        0    21      19

I need it in one select since it;s the base for a par. view...

TIA
Jaime