I want to set remaining field values to be the first field value I set like setting defaults. I do a calculation to get field1 value:
SET FCMP = cost * multiplier,
Price2 = FCMP,
Price3 = FCMP
is this doable and if not is there a way to do this?
The calculation to get FCMP is much more complicated than above and it involves a few sub queries but for my example I made it simple.