[odb-users] How to change the join type of relations in a view

[Boris Kolpackov]

Hi Ali,

adanesh at noornet.net writes:

>     r += "FROM \"TagIndex\"";
> 
>     r += " INNER JOIN \"SubjectIndex_tags\" ON";
>     r += "\"SubjectIndex_tags\".\"value\"=\"TagIndex\".\"id\"";
> 
>     r += " LEFT JOIN \"SubjectIndex\" ON";
>     r += "\"SubjectIndex_tags\".\"object_id\"=\"SubjectIndex\".\"id\"";

Object relationships are always translated to LEFT JOIN, there is no
way to change that and I believe there should be no need either. Can
you show a situation where changing it to INNER JOIN will make a
difference?

Boris