--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 <[EMAIL PROTECTED]> wrote: > Column Col3 should carry forward and sum values from Col2 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]