Thursday, March 14, 2013

How to update tables by inner join in SQL

update L
set l.Text ='something'
from [aTable] a
inner join [bTable] b on a.Id = b.aId
where a.id = 1

No comments:

Post a Comment