Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

how to make update in a table using data from an other left join table

When I look at the databse forum, i found the syntax for update very confusing. Could it be consistent with other sql syntax :

UPTADE table1 Left join table2 on di1=id2 Set table1.field1=table2.field2 ? Thanks