I have an email campaign table that I import email lists to from various led gen.
I have a client intake table that I use to track when a client submits a proposal request and eventual becomes a client.
Email is the unique client identifier across all tables.
I need to search my client intake table to see if any of the 'email' field matches an 'email' in my campaign table.
If it does I need to grab the 'status' from the client intake table and update the 'status' on my email campaign table.
The reason I do not want to link the tables is I have a ton of records that do not need to be brought over from one table to the other. I just need to know if a client engages or status changes after I email them.