I have a SQL select with a simple join.

When completed, the records are in the reverse order for matching children keys. In other words, I have an 'order by' statement that orders by the child-key, and that part works fine, but within each group of child-key records, they are now in the reverse order from what they were originally entered into the table.

This does NOT happen if I eliminate the join step.