So I have a table that is made up similar to this
group_id | code |code_type 1 45 '9' 2 56 '0' 3 56 'NA' 4 32 'NA'
The problem is that I have multiple code_types for the same code, but that’s okay, but when there is an ‘NA’ I want to delete it from the table, because obviously we have another code_type that specifies that code. So we don’t need that ‘NA’. Hopefully this makes sense, I’ll be glad to clarify if needed. So when it’s all said and done we will delete row 3 and keep the rest.