Joins in 3.5

[Ruslan Zasukhin]

On 10/12/07 4:04 PM, "Fabian Eschrich" <info at faesch.de> wrote:

Hi Fabian,

> Hi Ruslan,
> 
> didn't you change the way valentina works with joins in release 3.5?

We did !

And this was one of major 3.5 addition,

Actually we did not change, but improve it.
We have add ability specify FILTER conditions in the ON clause

SELECT 
FROM T1 join T2 ON T1.id = T2.ptr AND T1.f1 = 15 AND T2.f3 < 22
                                  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
 
This is SQL Standard Syntax.

And it ESPECAILLY important of used with OUTER JOINS.

> I still have the problem, if table b has no records corresponding to table
> a, the left outer join query does not return the whole row.

I not remember if this was you who have request this feature...

Okay, show us your task.
    db, query...


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