HomeActive Query Builderadd Derived table from code

add Derived table from code


Hi,

I tried to add a Derived table from code, I don't know how to do this, please help me

Thanks
Shlomo | email
May 28 2008, 04:22 AM
Hi,

You can use following statement to add a derived table:

queryBuilder1.ActiveSubQuery.ActiveUnionSubquery.AddFromExpression("(select OrderID from Orders) d1", "d1");

The query alias in the first parameter is obligatory.
Sergey Smagin | email
2 days since original post
This topic is closed