+ 1
Update records based on another table value is possible or not?
eg: select id,name,age from students; select id,name,age from school; update students set age = age(school table) where id= id (school table);
1 Answer
0
you can use select in select.
update students set age = 28 where id in
(select id from schools)