I have a table populated using query1. For every row in that table, I need to run query2 and show the result of that second query inside a column for the corresponding row.
I’m aware that I can map data from query2 onto query1, but I’m unclear on how to execute query2 repeatedly, once per row.
Is this something that’s supported? I haven’t been able to find any guides or examples that cover this use case.