Muliples With joins

[dimagi]

Muliples With joins

[millerdev]

Hi @cchavez, you have not specified how first_with is related to second_with, so I cannot construct an example. They need to be joined somehow. test_named_ctes has examples of how to do this, but that test seems a bit more complicated than your situation, so I added simpler test (test_named_simple_ctes) with multiple joins

django-cte/tests/test_cte.py

Lines 210 to 216 in 4be459b

	orders = (
	region_count.join(
	totals.join(Order, region=totals.col.region_id),
	region__parent=region_count.col.parent_id
	)
	.with_cte(totals)
	.with_cte(region_count)

[cchavez]

@millerdev first_with and second_with are not related to each other, it's not a recursive with, they make two different calculation but I want to get both result in one single sql by join them with the Model0.

[cchavez]

@millerdev thank you for you help, I think I misunderstood the join method and I followed what to mentioned and it's working, it's generating the SQL that I expected.

I did the following:

first_with.join(second_with.join(Modelo0, id=second_with.col.id), id=first_with.col.id).with_cte(first_with).with_cte(second_with)...

And that generate the SQL that I expected, making the Model0 join with both second_with and first_with.

Than you very much for you help.