troubleshooting Question

Add a value to each line returned from a union

Avatar of ttist25
ttist25 asked on
Microsoft SQL Server
8 Comments2 Solutions70 ViewsLast Modified:

I'm creating a CTE using two select statements and a UNION of two tables.  I would like to add a "faux" column to the results to identify  which table each row came from.

Something like:

    SELECT field1, field2, field3, 't1' as Source
     FROM table1
     SELECT  field1, field2, field3, 't2' as Source
     FROM table2

The results would look like:
field1 | field2 | field3 | Source
   A     |      B    |     C     |     T2
   C     |      R    |     G     |     T1

Any idea how I can do that?

Join our community to see this answer!
Unlock 2 Answers and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros