<div>
So awesome, 
 
Thanks.
</div>

<div>
<div class="content wysiwyg-content">
I need to populate a table named &quot;TargetTable&quot;. 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 
PSUS_USER_ID &nbsp; &nbsp; FUAD_ITS_CLERK_ID &nbsp; &nbsp; 
 
s611581 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CRAB &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
c611689 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEXY &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
y657888 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MUNC &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 
 
 
Table2 -- SMT_ADMN_PSUS_PR_STE_USERS 
PSUS_USER_NUM &nbsp; &nbsp;PSUS_USER_ID 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;s611581 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;c611689 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;y657888 
 
 
TargetTable -- Currently no data 
PSUS_USER_NUM &nbsp; FUAD_ITS_CLERK_ID 
 
 
 
 
 
TargetTable -- After a query is run to populate TargetTable 
PSUS_USER_NUM &nbsp; &nbsp;FUAD_ITS_CLERK_ID 
1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CRAB 
2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;LEXY 
3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MUNC
</div>
</div>

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
PSUS_USER_ID     FUAD_ITS_CLERK_ID    

s611581          CRAB                 
c611689	         LEXY                 
y657888          MUNC                 


Table2 -- SMT_ADMN_PSUS_PR_STE_USERS
PSUS_USER_NUM    PSUS_USER_ID 
1                s611581 
2                c611689 
3                y657888


TargetTable -- Currently no data
PSUS_USER_NUM   FUAD_ITS_CLERK_ID





TargetTable -- After a query is run to populate TargetTable
PSUS_USER_NUM    FUAD_ITS_CLERK_ID
1                CRAB
2                LEXY
3                MUNC

Populating a table from two other tables

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.