Conver sql to orm django

[jose alejandro hernandez rosales]

Hi , everyone i have a little problem, how do I convert this sql sentence to ORM?

SELECT * FROM CLIENTS

LEFT JOIN rutas ON

clientes.ruta_id = rutas.ID

LLEFT JOIN repartidores ON

clientes.ruta_id = repartidores.ruta_id

[Erik Cederstrand]

This should work:

Client.objects.select_related('ruta').prefetch_related('ruta__repartidores')

But you should really post your model code so we can see how the foreign key and many-to-many relations are defined.

Erik