I'm still not sure how to write nested CASE WHEN statements. I have another one that I need help with.
Here is the criteria: IF J1.SOKey IS NOT NULL Then '01' ELSE IF J1.SOKey IS NULL and J2.RMPartNo IS NOT NULL then '04' AND IF J1.SOKey AND J2.RMPartNo are BOTH NULL then A2.fprodcl
Any help would be appreciated. I'm learning these but still have some trouble with the nested ones.