ok uys, firstly thanks for your prompt response I have noticed one error in that I am not trying to update with the software name amended when i should be
secondly I hope this can explain it further
if table 1's software_name_raw = table2's software_name_raw then
I want to update table 1s rows with table 2's software_name_amended value of what it should be.
for example the 4th row should change to Visio 2003 Viewer
the 6th row should change to Visio 2007
if there is no match then just leave table1's software_name_raw value as it is
I hope this helps you guys as I am now starting to confuse myself further lol
TABLE1-COL1 called software_name_raw
Microsoft Office Visio Viewer 2003 (English)
Microsoft Office Visio 2003 Step by Step
Microsoft Office Visio 2003 Step by Step
Microsoft Office Visio Viewer 2003 (English)
Microsoft Office Visio Viewer 2003 (English)
Microsoft Office Visio 2007 (Exe)
Microsoft® Office Visio® 2007
Microsoft® Office Visio® 2007
Microsoft Office Visio 2007 Professional Edition
Microsoft Office Visio Professional 2007
Microsoft Office Visio Viewer 2007
Microsoft Office Visio Viewer 2007
Microsoft Office Visio Viewer 2007
Microsoft Office Visio Viewer 2007
Microsoft Office Visio 2010
Microsoft Office Visio 2010
Microsoft Office Visio 2010 (Exe)
Microsoft Office Visio 2010 Premium Edition
Microsoft Office Visio 2010 Professional Edition
TABLE2-COL1 also called software_name_rawTABLE2-COL2 called software_name_ammended
Microsoft Office Visio Viewer 2003 (English),Visio 2003 Viewer
Microsoft Office Visio 2003 Step by Step,Visio 2003 Step by Step
Microsoft Office Visio 2003 Step by Step,Visio 2003 Step by Step
Microsoft Office Visio Viewer 2003 (English),Visio 2003 Viewer
Microsoft Office Visio Viewer 2003 (English),Visio 2003 Viewer
Microsoft Office Visio 2007 (Exe),Visio 2007
Microsoft® Office Visio® 2007,Visio 2007
Microsoft® Office Visio® 2007,Visio 2007
Microsoft Office Visio 2007 Professional Edition, Visio 2007 Professional
Microsoft Office Visio Professional 2007,Visio 2007 Professional
Microsoft Office Visio Viewer 2007,Visio 2007 Viewer
Microsoft Office Visio Viewer 2007,Visio 2007 Viewer
Microsoft Office Visio Viewer 2007,Visio 2007 Viewer
Microsoft Office Visio Viewer 2007,Visio 2007 Viewer
Microsoft Office Visio 2010,Visio 2010
Microsoft Office Visio 2010,Visio 2010
Microsoft Office Visio 2010 (Exe),Visio 2010
Microsoft Office Visio 2010 Premium Edition,Visio 2010 Premium
Microsoft Office Visio 2010 Professional Edition,Visio 2010 Professional