Quote:
i want to update the column locked value as 1
where Aid=xx (tableA)
UPDATE tableA
SET locked = 1
WHERE Aid = [some value]
Quote:
in tableB
all Aid column with matching value xx then locked value as 1
UPDATE tableb, tablea
SET tableb.Locked = 1
WHERE tablea.Aid = tableb.Aid and tablea.Aid = [some value]
Quote:
in tableC
all Bid column with affected tableB then locked value as 1
UPDATE tableb, tablea,tablec
SET tablec.Locked = 1
WHERE tablea.Aid = tableb.Aid
and tableb.Bid = tablec.Bid
and tablea.Aid = [some value]
You can also take a look at the below links
Mastering the SQL UPDATE Statement[
^]
UPDATE Basics in SQL Server[
^]
Hope this helps.