Below is the table structure. Based on the child and parent status want to populate result column. ][ These three records is a one config. If any one of the child or parent has status as compliance then result should be populated as Investigate for entire config or else it should be default. Want to know how can we achieve this using sql statement.
ID Parent_Child_flag Status Parent status Result
----------------------------------------------------------------------
1 C non compliance non compliance
2 C compliance non compliance
3 P non compliance
You need to sign in to view this answers