Updating a table with only one occurence of row from another table

• Dinakar Nethi-176633

  SSCarpal Tunnel

  Points: 4689

  More actions

  April 21, 2005 at 11:57 am

  #554174

  SELECT

     DISTINCT [Unique ID],

     SUM([Line Amount])

  FROM

     <tablename>

  GROUP BY

     [Unique ID]

   

   

  ******************
  Dinakar Nethi
  Life is short. Enjoy it.
  ******************

• noeld

  SSC Guru

  Points: 96590

  More actions

  April 21, 2005 at 2:01 pm

  #554210

  you don't need "distinct"

  SELECT

   [Unique ID],

      SUM([Line Amount])

  FROM

      <tablename>

  GROUP BY

      [Unique ID]

  
  * Noel

• Louise-213220

  SSC-Addicted

  Points: 484

  More actions

  April 22, 2005 at 4:43 am

  #554307

  Thanks very much - that works fine