alan_lynch (3/6/2013)

---

Sorry Lynn

The BigTable.software_name_raw contains

SOFTWARE_NAME_RAW

Microsoft Office 2003 Professional Edition, Office 2003 Professional

Microsoft Office 2003 Professional Enterprise Edition, Office 2003 Professional

Microsoft 2003 Office Professional, Office 2003 Professional

and the RefTable contains a further column

SOFTWARE_NAME_RAW,SOFTWARE_NAME_AMENDED

Microsoft Office 2003 Professional Edition, Office 2003 Professional

Microsoft Office 2003 Professional Enterprise Edition, Office 2003 Professional

Microsoft 2003 Office Professional, Office 2003 Professional

So if the two columns match then update the BigTable with the software_name_amended column from the RefTable

If there is no initial match then I want to insert into the RefTable a new found reference

EG Microsoft 2003 PRO, 'Needs Updating'

Hope this helps