Hello all, I'm still new to postgres
If I have 2 tables with the following data structure
Agentno and agentname (along with many other fields) this table is called
agent_master
And I have another table with agentno and agentname. Table called
updatetable
When I add data in the updatetable, I want to write a query that will enter
the agentname field in the corresponding agent_master.agentname field based
on agent_master.agentno = updatetable.agentno
Thanks in advance