Home > database >  I am a novice, help me!!
I am a novice, help me!!

Time:09-24



I find out the customer field Nilsen and Jensen corresponding OrderPrice fields and
And output to the customer, and they and?

CodePudding user response:

Pictures don't show ~

CodePudding user response:

To understand a bit of a mouthful,
='Nilsen' the sum (the if (the customer or the customer='Jensen', OrderPrice, 0))

CodePudding user response:

The
refer to the original poster longdiwo response:
I find out the customer field Nilsen and Jensen corresponding OrderPrice fields and
And output to the customer, and they and?
 
Suggest you to provide detailed information:
Such as the structure table, table, the relationship between the test data, related algorithm and the result of the need,
So help us to understand what you mean, more important is to be able to let you get the answer or solution to the problem as soon as possible,

  • Related