update [Table_Name] set Type='Virtual' where Student_ID in(select Student_ID from [Table_Name] where Type='Hardware' and product='solution'); I...
Separate names with a comma.
