Re: [GENERAL] Aggregates and Joins

Bob Dusek wrote:
...
  >table second_table (
  >
  >   this_id int,
  >   price money,
  >   ...
  >   ..
  >   trans_id int, -- my primary key association
  >
  >);
...
  >What I need to do is to obtain the sum of the field 'price' from
  >second_table for every distinct 'trans_id' (all of which can be found in
  >first_table). ... Is there a quicker way to do this?  Is it possible to
  >use the aggregate functions and have more than one row returned?

select sum(price) from second_table group by trans_id;

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Jesus saith unto him, I am the way, the truth, and the
      life; no man cometh unto the Father, but by me."
                                         John 14:6