Here it is my SQL queries
how to union the 3 tables
SELECT
*
FROM [ERS].[dbo].[Transactiond] TD
union
[ERS].[dbo].[Transactionb] TB ON TD.[Transaction No]=TB.[TransactionNo]
union
[ERS].[dbo].[Transactionh] TT ON TDC.[Transaction No]=TT.TransactionNo
please help me this
thanks