UpdateQuery-from one table to another

[AmyLynnHill]

I created the following update queary to extract data from one table and update a field in another. When I run the query it gives me a prompt for the AGENT NUMBER which is the final statement in the query. I'm sure this is user error....can anyone help?

UPDATE MainPendingTable
SET MainPendingTable.AgentAddress1=DW_TEST_D_AGENT.ADDRESS_LINE
WHERE MainPendingTable.SOURCE_AGENT_ID=DW_TEST_D_AGENT.AGENT_NUMBER;

 

[tkpstock]

I created the following update queary to extract data from one table and update a field in another. When I run the query it gives me a prompt for the AGENT NUMBER which is the final statement in the query. I'm sure this is user error....can anyone help?

UPDATE MainPendingTable
SET MainPendingTable.AgentAddress1=DW_TEST_D_AGENT.ADDRESS_LINE
WHERE MainPendingTable.SOURCE_AGENT_ID=DW_TEST_D_AGENT.AGENT_NUMBER;

I don't know if it was a typo, but appears that you have an extra space in AGENT_NUMBER - your post says A GENT_NUMBER

Make sure AGENT_NUMBER is a field in DW_TEST_D_AGENT and that it is spelled correctly.