Left outer join with additional conditions in django

I have problems with this SQL with django queryset + Q objects.

How can I do this without a raw request?

SELECT * FROM Table1 T1 LEFT OUTER JOIN Table2 T2 ON T1.id == T2.fk_id AND (T2.VALUE = 'val1' OR T2.VALUE IS NULL)

+4

django left-join django-orm django-queryset

juanpex Sep 08 '13 at 9:02

No one has answered this question yet.

See related questions:

1433

LEFT JOIN vs LEFT OUTER JOIN in SQL Server

263

Getting SQL from QuerySet Django

233

What is the difference between select_related and prefetch_related in Django ORM?

148

Linq to Sql: Multiple Left Outer Joins

eight

Linq-to-Entities: LEFT OUTER JOIN with WHERE clause and projection

6

How to exit an external connection with an additional condition in Django

2

Django 1.8 conditional annotation leads to INNER JOIN instead of LEFT OUTER JOIN

2

Django queryset LEFT OUTER JOIN against another request as a subquery

2

django left outer join with condition

0

Django - external union of 2 queries into 1 query set without raw sql

Source: https://habr.com/ru/post/1501144/

All Articles