Hi,
Is it possible to use Django select_related()
function to return records even if they do not appear in both tables? e.g.
table 1
===========
id | title
1 title 1
2 title 2
3 title 3
table 2
============
id | table_1_id | cat
1 1 cat 1
2 1 cat 2
3 3 cat 3
assume table 1 maps to Django model TableA and table 2 maps to Django model TableB
TableA.objects.select_related('TableB').all()
How do I get the code above to return records 1,2 and 3 from table 1 rather than only records 1 and 3 which it currently does.
Thanks