How can I union in this stage (Choose Table or Specify Query Window)

[ryanzhang487]

Hi community,

I have around 10 tables in this step that I want to choose, and they all have same column, is there a way to union in this stage? or do I need to 'input data' first for each table and then union later?

Thanks

[Luke_C · Accepted solution]

Hi @ryanzhang487 

Click the plus button in the top right for however many tables you need. Then click into each 'Q' and add one table each. This should write the query with the union syntax (below in case you want to just do it in the editor)

SELECT column_name(s) FROM table1
UNION
SELECT column_name(s) FROM table2;