I'm trying to create a sql query by which the 2nd and 3rd case statement must be based on the 1st case statement .
My question is can we create 2nd and 3rd case using the result from 1st case statement in a single query.
Below is my query,when i run it,for example my uompointer=1800,my cq=1800,then based on the 2nd case statement,my arstat support to be Complete, but it display Partial.
Can anybody assist me on this error?
asked Dec 04, 2017 at 08:15 AM in Default
It is possible, you need to nest the cases
like the following
answered Dec 04, 2017 at 09:58 AM