Join two GoogleSheet Queries in a single table

App Building
1

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
Table1
image

Table 2
image

Query
image

2

I have tried in this way unsuccessfully
image

3

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...

image
image527×512 18.8 KB

4

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