troubleshooting Question

Populating a table from two other tables

Avatar of brgdotnet
brgdotnetFlag for United States of America asked on
Microsoft SQL Server
3 Comments1 Solution119 ViewsLast Modified:
I need to populate a table named "TargetTable". The data to populate the table
will come from two different tables. One named Table1 and another named Table2 .
I need to tage the FUAD_ITS_CLERK_ID data from Table1 and the PSUS_USER_NUM
value from Table2 and put it into the target table. I am just lost when it comes to
figuring out the query for this. I know how to join the two tables, but not how to get
the end result of populating TargetTable. Can someone help me?

Table1 -- Spreadsheet

s611581          CRAB                
c611689               LEXY                
y657888          MUNC                

1                s611581
2                c611689
3                y657888

TargetTable -- Currently no data

TargetTable -- After a query is run to populate TargetTable
1                CRAB
2                LEXY
3                MUNC
Koen Van Wielink
Business Intelligence Specialist

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 3 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 1 Answer and 3 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