Hi there,

How do I do this...

SELECT * FROM DerivedTableDefinition

Actually I want to add a GROUP BY in there but I can't see how to use a DerivedTableDefinition without joining to it and selecting entities that join to it.

Cheers, Ian.

I'm sorry but I'm not following.

Derived tables, are temp tables created to be joined in queries. Could you please explain in details what you are trying to do.

Set the left operand of a dynamic relation to the derivedtable definition, and leave the right operand as null.