Hope somebody can help. My query updates a colomn in tab1 from a row in tab2 but only if a colomn in tab1 is equal to that of a row in tab2.
tab 1 has 360000 rows
tab 2 has 477 rows
The update query runs for ages and still does not complete or when I execute it seems nothing has been updated.
Hopefully we can make this quicker. Thanks
I currently have this update query
update tab1, tab2 set _tab1.info = tab2.info where tab1.info2 = tab2.info2;