I am having two tables, table A has the following fields:
cust_ID, email
Table B has the following fields:
ID, email, name
I want to move email from Table A to B when the cust_ID = ID.
Please notice that both tables are filled with the same ids..
Anyone can help with my sql statment for this