I have a problem.  I just inherited a program that is full of holes and bugs
and I need to do some patching.  Just to note everyone, I did not set up
this database and I did not code this program, I am stuck with it as is.
That being said,  I have to do some checks on a database to make sure pairs
of material are in the same carton.

For example.  In carton 12345 pieces 1A and 1B must be in the carton.

The table is set up as follows:

Piece varchar(12)
InspectedByDate Datetime
InspectedBy varchar(20)
CartonNumber varchar(15)
Traveler varchar(8)

So the data should look like the following:

1A    5/5/2008    RR    081064    55132R
1B    5/5/2008    RR    081064    55132R
2A    5/5/2008    RR    081064    55132R
2B    5/5/2008   RR    081064    55132R
...

I can do a quick check to make sure there are an even number in the carton,
what I need help on is matching up the A and B pairs in the table.  I though
of grabbing all the "A" pieces then using a sub-query to do a like search
for "B" pieces, but am stuck. Anyone have any suggestions?

John