Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › eCart › eCart General / Announcements › recordset self join

recordset self join

Thread began 5/22/2016 4:47 pm by Christopher West | Last modified 5/24/2016 9:43 am by Christopher West | 613 views | 5 replies

5/23/2016 3:55 pmRay BorduinWebAssist

You are going to have to alias in any columns from the second table as well, like:

SELECT categories.*, selfJoinedChildren.CategoryID AS ChildID, selfJoinedChildren.CategoryName AS ChildName from categories LEFT OUTER JOIN categories AS selfJoinedChildren ON categories.CategoryID = selfJoinedChildren.CategoryParentID

But really the more I think about it, you probably want to use a nested recordset instead so you can order them properly and get the nesting correct.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.