2
Answers

How to union the table with the 3 different tables columns

Photo of Mahesh Babu

Mahesh Babu

6y
461
1
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)