Grouping might help me but how?

[jnuneznyc]

HERE is my tables layout
Pages
ID [int]
ParentID [int]
PageName [varchar]
...

All master pages' ParentID = 0
I need to pull a query from the database of all the pages and sort the list by PageName and have the children pages come right after their parent page.

[nnichols]

Try something like this -

SELECT p1.ID, p1.ParentID, p1.PageName, p2.ID, p2.ParentID, p2.PageName
FROM Pages AS p1, Pages AS p2
WHERE p2.ParentID=p1.ID
AND p1.ParentID=0

I haven't tried it, but I think it's correct.

If it doesn't produce what you want post again including some sample data (take a small data dump from the table) and I'll have another go.

Good luck 😉

[jnuneznyc]

Thanks!!! That did it.