V4MD 4.5

[Ruslan Zasukhin]

On 2/19/10 9:52 PM, "Steve Albin" <steve at steve-albin.com> wrote:

>> This query returns the same 15 records without errors
>> 
>> SELECT DISTINCT _type_album.recID, concat (width, '*', height) as
>> 'dimensions'
>> FROM _type_album, _jonction_album
>> WHERE (activation = TRUE AND idAlbum = _type_album.recID)
>> ORDER BY _type_album.recID
>> 
>> 
> 
> Last October, I reported a problem with SQL (Mantis id #
> 0004601) where I was not including the order by field in the
> result table.  I was told that this was not allowed according to
> SQL standards.  So, if that is the case, why is it not obvious
> that Christian's SQL is just incorrect?  Which is it?  Do we
> need to have the order by field in the result table or not?  Am
> I missing something?

I not remember from head, we will ask Ivan tomorrow.

May be for single table we have enable this "non-standard" feature.
For join may be no.

I just not remember.


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