sql - Update table based on another table - Stack Overflow

I'm trying to update a column in a table based on another column in another table . UPDATE eval e SET rank = (SELECT p.desc FROM Position p WHERE p.id ... Try this for SQL Server:

stackoverflow.com