posted 16 years ago
Please Please need Help with this question..
A department entity is in a one to Many relationship with the Employee entity. A developer has been asked to write a query to update the set of employees who are in the department HR by setting their department to null.
Syntax fragments:
Set
e.department.name
('HR')
where
e.department
=null
Employee e
Update
IN
According to me its:
Update Employee e Where ('HR') IN e.department.name Set e.department=null
Please tell me how should the query be formed.
And any links for further learning such query formation would be appreciated.
thanks,
mallika