update s1 set age=(select b.age from s1 a, s2 b where a.id = b.id) where name in (select b.name from s1 a, s2 b where a.name = b.name)
where a.id = b.name
(select b.age from s1 a, s2 b where a.id = b.name)
age
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)