DISTINCT not working ????

[Ruslan Zasukhin]

On 13/3/07 4:28 PM, "Bart Pietercil" <bart.pietercil at gmail.com> wrote:

> Hi,
> 
> This query
> 
> SELECT DISTINCT(oc_name) FROM organisation_cells WHERE oc_coach_ptr = 1
> 
> fails with  : unexpected token :)
> both from within VStudio as from within V4RB
> 
> Server 2.5.7
> 
> 
> It seems to me distinct is broken :-(
> 
> I must say I don't understand that basic sql statements fail in a 2.5
> version

Try 

SELECT DISTINCT oc_name FROM organisation_cells WHERE oc_coach_ptr = 1


-- 
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]