master item 1 apple 1 banana 1 pear 2 tomato 2 apricot 3 squash 4 turnip 4 orangeI want to get this:
master # item 1 1 apple 1 2 banana 1 3 pear 2 1 tomato 2 2 apricot 3 1 squash 4 1 turnip 4 2 orangeIs there a way to do this with SQL? It seems like there should be, but it's eluding me. I'm trying to number the items so I can combine a bunch of records into one in a different SQL so I can print the labels I was asking about earlier.