List:General Discussion« Previous MessageNext Message »
From:Mark Stafford Date:August 13 2004 8:40pm
Subject:Re: Using SUM in a special way
View as plain text  
--Try this, using variable @foo:

SELECT t1.col1, t2.col2, @foo := @foo + (t1.col1 * t1.col2) col3
FROM t1

On Fri, 13 Aug 2004 15:29:18 -0700, Mauricio Pellegrini
<hrrg-inf@stripped> wrote:

> Column Col3 should carry forward and sum values from Col2
Thread
• Using SUM in a special wayMauricio Pellegrini13 Aug
  • Re: Using SUM in a special waySGreen13 Aug
  • Re: Using SUM in a special wayMark Stafford13 Aug
  • Re: Using SUM in a special wayKeith Ivey13 Aug
    • Re: Using SUM in a special wayMauricio Pellegrini13 Aug