if the tables are from same connection then Yes.
you may also try Tableau Prep
One of the important point to notice is as below (apart from the complete blog )
For best results, the tables that you combine using a union must have the same structure. That is, each table must have the same number of fields, and related fields must have matching field names and data types.
For example, suppose you have the following customer purchase information stored in three tables, separated by month. The table names are "May2016," "June2016," and "July2016."
DAY CUSTOMER PURCHASES TYPE 4 Lane 5 Credit 10 Chris 6 Credit 28 Juan 1 Credit
DAY CUSTOMER PURCHASES TYPE 1 Lisa 3 Credit 28 Isaac 4 Cash 28 Sam 2 Credit
DAY CUSTOMER PURCHASES TYPE 2 Mario 2 Credit 15 Wei 1 Cash 21 Jim 7 Cash
A union of these tables creates the following single table that contains all rows from all tables.
DAY CUSTOMER PURCHASES TYPE 4 Lane 5 Credit 10 Chris 6 Credit 28 Juan 1 Credit 1 Lisa 3 Credit 28 Isaac 4 Cash 28 Sam 2 Credit 2 Mario 2 Credit 15 Wei 1 Cash 21 Jim 7 Cash
Please mark the relevant answers as HELPFUL and CORRECT.
You can drag tables, not Custom SQL.
Can you create 2 views (With your Custom SQL) & then combine those 2 VIEWS (or say tables)
I see. That's a bummer.
What do you mean by "create 2 views"?
I am expecting views to emerge as tables
Why use Custom SQL though ?
Why are you trying to union 2 custom queries? You may just union 2 tables in 1 Custom query.