On Sun, 2005-02-20 at 16:32 -0500, phil campaigne wrote:
> hardwoodthunder=# select player_number, player_name, cum_score, (select
> player_points where aspect='A') as A ,(select player_points where
> aspect='C') as C, (select player_points where aspect='T') as T from
> (select * from player as
I see that I need another qualifier, cum_score in the select statement,
but I still need to consolidate the rows:
hardwoodthunder=# select player_number, player_name, cum_score, (select
player_points where aspect='A') as A ,(select player_points where
aspect='C') as C, (select player_points whe
Hi all,
I'm haveing trouble writing a select statement that gives me a resulting
row like this:
player_number, player name,a,c,t, (total of a+c+t).
here's what I have so far but it puts the a,c,t in separate rows.
hardwoodthunder=# select (select player_points where aspect='A') as
A,(select play
