Update within 2 tables using LIKE

[cumap]

Hello,
I'm trying to update a table with this query but doesn't seem to work at all

update tblCustomerThreads
SET UserID = tblContacts.idSalePerson, idCustomer = tblContacts.idCustomer
from tblCustomerThreads, tblContacts
WHERE tblCustomerThreads.idGoldMine LIKE %tblContacts.idGoldMine%

The query seems to run for a second and done, but I found no record has been changed. My guess is that it didn't find any match. Please help.

 

[jbenson001]

You have to join your tables.

 

[cumap]

Please help me verify the query as you mentioned because I, now, cannot test it because Godaddy server is down somehow.

update tblCustomerThreads
SET UserID = tblContacts.idSalePerson, 
idCustomer = tblContacts.idCustomer
FROM tblCustomerThreads
LEFT JOIN tblContacts
ON tblCustomerThreads.idGoldMine LIKE %tblContacts.idGoldMine%

thanks!

 

[jbenson001]

verify it once the server is back up by doing a select instead of an update. Verify what is returned and then run the Update if all looks right.