Re: Selecting rows as if they were columns?

Kurt,

> I've got what I think should be a pretty simple problem- I just can't
> figure out how I'd do it.  Heck, I can't even figure out how I'd search
> for an answer to this problem.

This is an old common SQL problem ... the "crosstab" table.   There are 3 
standard ways to solve it, depending on the exact circumstances of your case.   
It's probably best if you buy Joe Celko's "SQL for Smarties, 2nd Ed.", which 
has a 50-page chapter on the topic and explores the methods in detail.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco