This should do what you want:
UPDATE Table2, Table1 SET
Table2.DataDestination=Table1.DataSource WHERE
Table1.col1=Table2.col1 AND Table1.col2=Table2.col2
AND Table1.col3=Table2.col3;
--- PandaCoop-Krasimir_Slaveykov <[EMAIL PROTECTED]>
wrote: > Hello mysql,
> I have 2 tables :
>
> Table1:
Hello mysql,
I have 2 tables :
Table1:
col1
col2
col3
DataSource
Table2:
col1
col2
col3
DataDestination
How to update Table2.DataDestination with value of Table1.DataSourse
where table1.col1=table2.col2 and table1.col2=table2.col2 and
table1.col3=table2.col3
--
Best
