views:

27

answers:

0

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