Re: Getting emails from one table for another

[Phillip Ward]

Quote

... a query to check all the custid rows in the second table and if there is a corresponding email in the first table then it puts it in the second table emails field.

But the records in the second table are Agent-dependent (agent appears in the table's Primary Key), while those in the first table are not (no agent in the Primary Key). If you were to do this, you would take any email for the customer, regardless of the Agent involved, and "add" it to the Agent-specific table.

I second Peter's question - why do you feel the need to do this?
What are you trying to accomplish?

Regards, Phill W.