Tuesday, 28 August 2012

update two tables in one statement in SQL


UPDATE Table1
SET Table1.LastName = 'XXXXXX'
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '01'

No comments:

Post a Comment