Hi..Data (illustrative) in SQLite3. Have a few million rows, actually.
a, aardvark
a, anvil
a, apple
a, automaton
b, apple
b, peanut
b, persimmon
b, walnut
Key for my data is actually multiple columns but here I've just used the first column.
So, I'd like to find all the keys that are associated with apple, then use that to query all the other values associated with those keys.