KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
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 .
Tags (comma-separated)
Save Edits
Cancel