Join two GoogleSheet Queries in a single table

I would like to join two queries into a single table. The concrete case is that I make two GoogleSheet spreadsheet queries and I would like to put the result of the queries concatenated (joined) in a single table.
I used 'select * from query1, query2' but, the preview shows only the second query twice

Table 2


I have tried in this way unsuccessfully

I achieved! but it is very strange... maybe the SQL commands are not being interpreted well. only works if list all columns one by one...

Hi @PepeVergara, nice find! It looks like this might be a bug in Alasql which Retool uses under the hood for Query JSON with SQL queries.

1 Like