Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 25, 2010 09:43 AM by Velosai
Member
6 Points
13 Posts
Feb 25, 2010 09:43 AM|LINK
Trying to create a query that outputs a table in it's hierarchical state, but can only seem to get about half way. Any help would be great
tblGroups:
Group_ID - AutoNumber Group_Name - String(100) Group_Short - String(10) Group_Parent - Integer
Query so far:
SELECT Group_ID, Group_Short, Group_Parent FROM tblGroups WHERE Group_Parent In (SELECT Group_ID from tblGroups) OR Group_Parent is null
Velosai
Member
6 Points
13 Posts
Simple Data hierarchy table
Feb 25, 2010 09:43 AM|LINK
Trying to create a query that outputs a table in it's hierarchical state, but can only seem to get about half way. Any help would be great
tblGroups:
Group_ID - AutoNumber
Group_Name - String(100)
Group_Short - String(10)
Group_Parent - Integer
Query so far:
SELECT Group_ID, Group_Short, Group_Parent
FROM tblGroups
WHERE Group_Parent In (SELECT Group_ID from tblGroups)
OR Group_Parent is null