How to make a many to one join?

Hi,
Hi, I use grafana 7.1 and want to use join to combine two influxdb measurements in table
One is junit data which has the result of each test.


One is build data which has the status of each build

These two are “many to one” joined by “build_number” filed.

I tried outer join transformation, but it only keeps one row of each build number.

Does grafana supports such many to one join?