Hi,

I might not be able to put my question in proper way so let me put the same question other way around.

-------- //some logic

-------- //some logic

where empid = (select empid from Emp where deptid=2)

Now in the above query the empid returns more than one empid. Hence the above syntax or way of implementation is wrong. I would like to know what would you do when you encounter a situation like this