Hi, Is it possible to calculate a field in a resultset
e.g. a product has "cost price" and "margin" attributes and I want to write a query that doesn't return these but rather the product of the two.
Regards Ciaran
select cost_price, margin, cost_price+margin as total_price from table;
Many thanks 🙂
