Member Avatar for bangla

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.

Edited by Ezzaral because: code tags
  • 2 Contributors
  • 3 Replies
  • 74 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for pritaeas

Replace expenseOrder with buyprice - refund

Member Avatar for bangla

Thanks. it worked.
one more question:

SELECT orderid, merchant, buyprice, commission, refund, (
buyprice - refund - commission
) AS profitOfEchOrder
FROM business
WHERE merchant LIKE "GO%"

Above code works.
Now how can i SUM profitOfEchOrder?

Edited by Ezzaral because: code tags
Member Avatar for pritaeas

Put SUM before the parenthesis.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.