Hi,
Someone pls correct the error.
SELECT orderid, merchant, buyprice, commission, refund, (buyprice - refund) as expenseOrder , (commission - expenseOrder ) as profitt
FROM business
WHERE merchant LIKE "GO%"
error:
MySQL said: Documentation
#1054 - Unknown column 'expenseOrder' in 'field list'
Thanks.