MySQL Forums
Forum List  »  Newbie

Re: Getting emails from one table for another
Posted by: Phillip Ward
Date: December 08, 2021 05:22AM


... 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.

Options: ReplyQuote

Written By
Re: Getting emails from one table for another
December 08, 2021 05:22AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.