Mahesh Babu

Mahesh Babu

  • NA
  • 118
  • 32.6k

How to union the table with the 3 different tables columns

Aug 18 2018 4:56 AM
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

Answers (2)