Women in Technology

Hear us Roar


Article:
  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?


Thanks


Andy

Recommended for You
 
Sign up today to receive special discounts,
product alerts, and news from O'Reilly.
Privacy Policy >
View Sample Newsletter >