[development-axapta] select calculated value as field

[Byteway]

Hi,

Is there an alternative for:

  select sum( field1 * field2 ) as newField from table;


And can it be any better then:

  while select field1, field2 from table
  {
    newField += field1 * field2;
  }


What is a better alternative?


Thanks,
/b