Is it possible in LLBLGen v2.6 to JOIN on a function call, like so:
LEFT JOIN fn_ContactCodeList() d ON d.ContactID=c.ContactID
[edit]
I was thinking I could wrap the function call in a Derived Table, but when I look at your sample code, I only see examples where there is ONE join, that to the Derived Table. It seems to me that if I add an appropriate DynamicRelation to my relations collection (which includes non-dynamic relations), then setting the relationscollection.SelectListAlias to reference to the derivedTable would throw the rest of the joins off? Or am I wrong?
Either way, how can I accomplish a SELECT that includes (but not exclusively) a join on a derived table?
Thanks,
Josh