sort not honored by join

Discussion created by armein01 on Mar 22, 2014
This may be a very simple question.
I can program a little with python and put to together queries.
I am working in ArcGIS 10 with soil data.
I want to sort the component table by a flag field with identifies the record as
a dominant component for the map unit, then sort by the key field.
Now the table has the records with a dominant component and there keys at the top.
Last I sort by the dominant component representative value, which puts the "most" dominant component at the top.
When I join now to the poly table by the key it should choose the correct record.  I thought Arc would choose the first matching record, but this isnt the output I am getting?
How should I be approaching this?  Everything is in a file geodatabase.