Getting emails from one table for another
Posted by:
J j
Date: December 07, 2021 07:29AM
Hello,
I have 2 MySQL tables.
The first has as its structure:
id
custid
emails
The second is as follows:
id
custid
agentid
emails (this is what needs to be filled)
The 'emails' field in the second table is empty and I need to fill it. Obviously the field in common for both tables to do this is custid.
So I would need 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.
Hope this is clear.
Thanks for any guidance.
Regards
Subject
Written By
Posted
Getting emails from one table for another
December 07, 2021 07:29AM
December 07, 2021 12:48PM
December 08, 2021 05:22AM
Sorry, you can't reply to this topic. It has been closed.
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.