I have a temporary table TEST_GROUP, from where I'm working its data to fill another one.
From this table, giving the example in the picture, my expected result is to group these three rows, so I can have a result like
INSERT INTO TABLEDATA Select * from TEST2 where (field1 = 'B') and (field2 = 'T') and (field3 != 'S' and field3 != '')
Easy to say that when the
EXP = EQ only validates the
VAL1, but when the
EXP=NE should validate
VAL2, even if
VAL2 is empty.
Not so easy for me to get the expected result.
Can you provide some guidelines how to get the expected result?