ONJava.com -- The Independent Source for Enterprise Java
oreilly.comSafari Books Online.Conferences.


AddThis Social Bookmark Button
  SQL Subqueries
Subject:   Do I need a subquery?
Date:   2004-11-08 07:53:54
From:   andy_mcghee
Hi everyone. I'm pretty new to SQL and there is something I'm stuck with something.

Put simply, I have a table which stores information about groups. Now, some groups have sub groups and hence some groups have parents. So, there is a field called GroupGUID and a field called ParentGroupGUID. I want to write a query where I can get the description of the group and it's parent group. Both these groups are stored in the same table. I just cant think how to do this.

Am I being stupid?