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
