Hi @Yuxiu_Gan
A union all requires the same columns to be in the same positions for both queries.
For example you might look to do
select customer_id,date from table1
UNION ALL
select customer_id,date from table2
If the names are different you would need to rename them to a similar name.
I’m assuming that’s the issue.