SQL Update statement
Posted on 2014-01-23
I have two sql tables in a database.
Companies - contains acname (account name), outlettype
FirstNames - contains 1 column called 'names'
I have a list of our customers in the companies table.
I have a list of individuals first names in the Firstnames table.
I want to
update companies.outlettype to ELEC2 if the acname begins (starts) with any of the names exists in the firstnames.name column
basically i am trying to seperate individuals from companies to segment the data for marketing by updating the outlettype.
I have been doing the following statement on individual records using the following
SET OUTLETTYPE = 'ELEC2'
WHERE (ACNAME LIKE 'john %') AND (OUTLETTYPE IS NULL)
But i would like to do this on a large scale with 5495 first names that i have obtained in the FirstNames table
There are around 80,000 records in my companies table so doing them all manually will take a little time :-)
I would be grateful if you could help me with the query to do this mass update.