On Fri, 2003-04-04 at 11:10, Ali Adams wrote:
> Dear All,
>
> I am new to Relational Databases and SQL and my background in ODBs is
> clouding my way to solving what seems to be a simple problem. I am
> sure many of you have met it many times.
You need to use a pivot table.
Specifically, see crosstab() within contrib/tablefunc in the source
base.