Help with SQL Update query
Posted on 2011-02-28
I have 2 tables with customers
Tab_Customers have the following record layout.
Tab_Phone has the following recordlayout
In Tab_Customers there is no phone numbers present
In Tab_Phone there are no customernumbers present, but it has phone numbers present.
I would like to add the customer number to the Tab_Phone table where ever there is a big similarity on the name.
I have tried the following:
set Customerno = (
select c.Customerno from Tab_Customers c where exists(select * from Tab_Phone p where
similar (p.Firstname,c.firstname)<99 and
similar (p.Lastname,c.lastname)<99 and
similar (p.Adresse,c.adresse)<99 and
similar (p.zip,c.zip)<99 and
Is someone able to help me?