CODEWITHSUNDEEP
sql
Sami
Sami

Reputation: 1

I m trying to work on this update query

I m trying to work on this update query please help its not working

UPDATE Country set Country.CountryName = 'Swizz' 
from Country,Customers
where Customers.CustomerName='sameer'

Upvotes: 0

Views: 25

Answers (1)

RoMEoMusTDiE
RoMEoMusTDiE

Reputation: 4824

for SQL Server and a bit of tidy up

UPDATE C 
  set CountryName = 'Swizz' 
from Country C
Inner join Customers x 
  on x.country_code = C.country_code   --- missing component from OP
where x.CustomerName='sameer'

Upvotes: 1

Related Questions