nenu_devudni Posted April 12, 2013 Report Posted April 12, 2013 table for employees .. 3 coulums .. emp id , region , manager id - ref to emp id, to find out all the employees .. who dont have same region as their manager
timekiller Posted April 12, 2013 Report Posted April 12, 2013 Sel * from Emp a Inner join Emp b On a.empid=b.mgrid And a.rgnid<>b.rgnid
Recommended Posts