I need to update a table but need to link two other tables toghether
Posted on 2014-12-12
I need a query that will update "TableToUpdate" with data found in two other tables ADMIN_USERS
Basically I need to set the TableToUpdate.FUAD_ITS_CLERK_ID value to the SourceTable.FUAD_ITS_CLERK_ID
value. The challenge though, is that I also need to set the TableToUpdate.PSUS_USER_NUM value which I
will need to get from the ADMIN_USERS table. So basically I need to link 3 tables together.
Can someone help me to write the query. I don't know how to write it, however if someone can give me the query,
I will study it in detail, and make sure I understand how it works.
PSUS_USER_NUM (PK, numeric(5,0), not null)
PSUS_USER_NUM (numeric(5,0), not null)