Order by not possible in view?

[Ruslan Zasukhin]

On 20/7/07 3:40 PM, "Sims, John (CDC/CCHP/NCBDDD) (CTR)" <ayu8 at CDC.GOV>
wrote:

Hi John,

> Hi Ruslan,
> 
> I would like to add my "vote" for this one.  I use ORDER BY in SQL
> Server views all of the time.  Very useful!
> 
> I'm not sure if Valentina supports it, but GROUP BY and Aggregate
> functions are very useful in views also :-)

GROUP BY we support now.

VIEW can have in body query_expression.
This means UNIUON, SELECT, JOIN, GROUP BY, HAVING



-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]