I'm just full of questions today. :)

Say I have a table that looks like this:

   master     item
     1        apple
     1        banana
     1        pear
     2        tomato
     2        apricot
     3        squash
     4        turnip
     4        orange

I 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   orange

Is 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.

Thanks,

Michelle