Populating a table from two other tables
Posted on 2014-12-11
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
Table2 -- SMT_ADMN_PSUS_PR_STE_USERS
TargetTable -- Currently no data
TargetTable -- After a query is run to populate TargetTable