How to merge only 2 of 3 tables with same structure inside the table transformer macro?

[Santhosh Kumar]

Hi Team,

I'm looking to have 3 tables say T1, T2 & T3 inside the table transformer macro. All tables have same column structure.

And looking to merge only 2 tables at a time and display the merged table in the page. (Either T1 &T3 or T2 & T3).

Can you pls help with the SQL query on the same? 

Thanks and Regards,

Santhosh

[Santhosh Kumar · Accepted solution]

Have found the answer. Thanks

Select * from T1 

UNION

Select * from T3