Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

2
  • Ok.. Yeah I know about design issue. But I didn't share all information about departments. In fact each departments has a list of managers (see: post update) that why i splitted departements and employees. And you'r true about loop over but I wanted to know if it's possible to do this with simple query Commented Apr 24, 2012 at 14:24
  • I've updated my answer, in order to make this work, you'll need to redesign your schema. Commented Apr 24, 2012 at 15:10