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?

Thanks

Andy