Unless I am missing something one can't nest selects. Example: select field1, ..., (select something from sometable where ...) as NestedField FROM primarytable

It can be done through view or storedproc of course.

I guess you are not missing anything.

View is my precious object

lol, my preciousssss

Of course you can ScalarQueryExpression is your friend See: "Field expressions and aggregates" -> Scalar query expressions in the manual

Otis wrote:

Of course you can ScalarQueryExpression is your friend See: "Field expressions and aggregates" -> Scalar query expressions in the manual

Heya Frans,

Sh, how could I doubt :-) Any chance of getting this feature to designer?

For typed lists you mean? That falls into the same category as expressions. We thought about it, wrote some test setups but it all turned out to be more work for the user than simply writing a couple of lines of code. I.o.w.: it would make you less productive.