Avatar of tmajor99
tmajor99 asked on

SQL Select - Inserting a new column into the result set

I need a SQL Select that will insert a new column with a static values into the result set.  I need a new column called "Attribute Name" with the value set to "SUBS_ID" inserted into the result set from the SQL below,

SELECT TABLE1.ID, TABLE2.Trilogie_SUBS_ID  
FROM TABLE1
INNER JOIN TABLE2
ON TABLE1.S_MASTER.PRODUCT = TABLE2.S_MASTER.PRODUCT

This what I want the result set to look like:
ID         Trilogie_SUBS_ID       Attribute Name
303           600                          SUBS_ID
Microsoft SQL Server

Avatar of undefined
Last Comment
Scott Pletcher

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Brian Crowe

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Scott Pletcher

SELECT TABLE1.ID, TABLE2.Trilogie_SUBS_ID, 'SUBS_ID' AS [Attribute Name]
...
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy