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

Boris Kolpackov boris at codesynthesis.com
Tue Jul 5 06:49:31 EDT 2016

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


More information about the odb-users mailing list