Nested Decodes in TCC?
I need to do a nested decode in TCC. Basically I have a decode complex projection that works fine BUT i need to decode another table and field if the first table and field are null. So in pseudocode
(Decode Table1.Field1, 1, Yes, (Decode Table2.Field2, 2, Yes2, No2))