join multiple series value without any operator in table form

[M shr]

I am trying to join multiple timeseries value in table form and use it in my application.

I found left join in documentation but the problem is it must have a operator between two values for example:

proxy_rps + on (user, id) group_left( ) proxy_acc

I had to sum two values together but what I need is to see two values side by side.

something like SQL query which you can select multiple values and produce a table with single query 

Could anyone help on this please?  

[Brian Candler]

You need a separate promQL query for each value (i.e. each column in your table).  You can make multiple instant queries to the API with the same timestamp.