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 VAL1
and 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?