Re: Queryset from 2 models with second model filtered.

Typically I simply want to do a left join but have it as an object in django rather than a sql raw query. The queryset would look like. Select a.code as 'product_code', a.description as 'product_description', b.code as 'customer_code', b.code as 'customer_description', ifnull(

Queryset from 2 models with second model filtered.

Hi, I have a tricky one, I don't have an error but rather trying to avoid many database hits. I am trying to build a product database which can have different field values per customer. So the model would look something like this. class Customer(models.Model): name = models.CharField(max_le