JDBC Select one to many join MySQL and join snap

Hi,

i’m trying to join data from two MySQL sources. i’m using the Join snap using a left outer join but it only seems to be joining a few records.

in the scenario i’m joining one material to many prices, using the group by fields snap to group the prices by material.

image

It looks like because the MySQL Select works in batches that those batches might not always line up in the join - is there anyway to get all the pricing (i.e. not in batches) and then join to the materials?

what I want to end up with is something like this:
{
“materialCode” : “XYZ”,
“name” : “a material”,
“prices” : [
{
“materialCode” : “XYZ”,
“price” : 10.00
“currency”: “GBP”
},
{
“materialCode” : “XYZ”,
“price” : 10.00
“currency”: “EUR”
}
]