title: Query for replacing a column value in one table by its id in another table
body: <p>I have two tables employee and department, i want to replace department names from employee table by department id from department using a single query?</p>