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