I am trying to count child rows but cannot get it to work. The count keeps returning 1. I tried counting SiteFolders.Path and Pages.Directory. Can some one explain what I may be doing wrong?SELECT SiteFolders.Path, Pages.PageName, Pages.UniqueID, COUNT(SiteFolders.Path) AS ChildCountFROM SiteFolders LEFT OUTER JOIN Pages ON SiteFolders.Path = Pages.DirectoryGROUP BY SiteFolders.Path, Pages.PageName, Pages.UniqueIDORDER BY SiteFolders.Path
content contact_us 34 1content ThankYou 56 1content Events 61 1content PastEvents 62 1content ViewEvents 63 1content Directory 65 1content\child1 shjsdhjsd 66 1content\child1\baby1 uysuysd 67 1content\child1\baby1 kjs943jhi 69 1content\child2 lka87sd 68 1content\child2 oks8sd98oi 72 1