I'm trying to create a table which has two keys, but on of the keys auto-increments depending on the second key.
key1 | key2
------------
1 | NJ
2 | NJ
1 | CA
2 | CA
3 | CA
4 | CA
Now, with a single insert statement, I would like the next entry to be (3,'NJ'); the 3 being the next incremented value corresponding with 'NJ.
Can anyone point me in the right direction or give me any clues?
I would be MOST appreciative. TIA.
Arthur