We have a table: Forum ForumID ParentID Url Title

We want to write the following query using LLBLGen

select y.Url, y.title, x.Url, x.Title From Forum as x inner join forum as y on x.forumid = y.parentforumid where x.url = 'SOME URL'

We don't know how do we indicate which Url & Title we're looking for. Suggestions?

Thanks! -Jeff

jeffdeville wrote:

We have a table: Forum ForumID ParentID Url Title

We want to write the following query using LLBLGen

select y.Url, y.title, x.Url, x.Title From Forum as x inner join forum as y on x.forumid = y.parentforumid where x.url = 'SOME URL'

We don't know how do we indicate which Url & Title we're looking for. Suggestions?

Please see the section "Creating dynamic lists" in the using the typed list and typed view classes" in the documentation. Using the same entity more than once in a typed list is coming soon.