One to Many Relationship Finding Child Orders

[goidx]

On a one to many relationship. If the orderItems are not in the same order as the Order File. It fails to match the orderItems:

For example:

OrderId,Price
1,30
2,15
3,10

OrderId,Name
1,"Super Cool Item 1"
2,"Super Cool Item 2"
1,"Super Cool Item 1"
3,"Super Cool Item 3"
3,"Super Cool Item 3"
1,"Super Cool Item 3"

Array
(
[OrderId] => 1
[Price] => 30
[Items] => Array
(
[0] => Array
(
[OrderId] => 1
[Name] => Super Cool Item 1
)

    )

)
Array
(
[OrderId] => 2
[Price] => 15
[Items] => Array
(
[0] => Array
(
[OrderId] => 2
[Name] => Super Cool Item 2
)

    )

)
Array
(
[OrderId] => 3
[Price] => 10
[Items] => Array
(
)

)