I have a query that produces the following result set:
Effect. Date      Expir. Date       Cert. Type
7/23/2002         7/22/2005          O
5/10/2004         7/22/2005          P
7/23/2005         7/22/2008          O
7/23/2005         7/22/2008          P

The last two lines have the exact same dates.  Is there a way to rollup
the last two lines to give one line like
7/23/2005         7/22/2008          O, P

??

Mia J.

*** Sent via Developersdex http://www.developersdex.com ***

You can use the pivoting approach detailed at:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175574

Unknown Columns!
Simple query?
adding 140,000 records requires index rebuild. make sense?
Need advice with a query
Help with subquery