I am having two tables
- student table it contains (Student_id,school_code,name,year,...)
- school table it contains (school_id,School_code,School_name,year etc.....)
I want to update the school_code column in the student table with the school_id column in the school code table based on school code and year. i m having five years data. so school_id varies for every year.
My query was
UPDATE Master.Student
SET school_code=( select school_id from Master.school as sc
JOIN master.student as st
ON st.school_code=sc.school_code
WHERE sc.year=x)
WHERE st.year=x;
But its not updating. I am getting error of subquery returns more than one value
.
4条答案
按热度按时间zaq34kh61#
Why to use sub-query when you can do that directly?
For more info See UPDATE (Transact-SQL)
bprjcwpo2#
4nkexdtk3#
Try this query
dl5txlt94#