Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

How to union the table with the 3 different tables columns

Home
Forums
Learn iOS Programming

How to union the table with the 3 different tables columns

Mahesh Babu

8yAsked Aug 18, 2018, 4:56 AM642Learn iOS Programming

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Jignesh Kumar8y ago
If you want to do union on differnt table then your column datatype should be same then you can do union on more then one table
Suraj Kumar8y ago
Hello Mahesh,

You can learn more about union here

https://www.w3schools.com/sql/sql_union.asp

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/set-operators-union-transact-sql?view=sql-server-2017

To know the difference between UNION and UNION ALL you are requested to read the following articles

https://www.mssqltips.com/sqlservertip/1387/union-vs-union-all-in-sql-server/

You should write your query as below

SELECT

*

FROM [ERS].[dbo].[Transactiond] TD

union

SELECT * FROM [ERS].[dbo].[Transactionb] TB

union

SELECT * FROM [ERS].[dbo].[Transactionh] TT

The number of column and datatype of column should be same

please help me this

Thanks