Search results

I understand what you're trying to point out. Maybe it would be clearer if I changed the columns and its corresponding values. Let's change the "COLORS"and "ÜTENSIL" column into "TIMELINE" column having ('beginning' & 'end') as values AND "FORM" column having ('chicken' & 'egg') as values. So...

No, my statement still stands correct based on my intentions. I declare 2 rows in the table as a match when I get: - a blue fork & a red spoon OR - a red fork & a blue spoon 1 match means having 2 records with opposite utensils AND opposite colors

I understand that the topic title is vague as buzzwords can get so let me give some sample data below: Table "TARGET" PLATE COLOR UTENSIL 1 RED FORK 1 RED SPOON 1 BLUE FORK 1 BLUE FORK 2 BLUE SPOON 3 BLUE FORK 3 RED FORK 4 BLUE FORK 4 BLUE SPOON 4 BLUE SPOON 4 RED FORK 4...