How to merge two queryset django?

You know that Django allows for the creation of QuerySets from the database by making use of methods like filter() or exclude().

But can we create a QuerySet out of a combination of other QuerySets?

Say we wanted to create a QuerySet from data collected from two different models. The use of the filter() and exclude() methods would not help here.

Or we might be creating a QuerySet with complex inclusions and exclusions using the filter() and exclude() methods, and it would be simpler to create multiple QuerySets and then combine them into a single set.

It is possible to combine QuerySets into another QuerySet, and they do not have to be from the same model.

The Python union operator can be used to combine QuerySets that belong to the same model.

Two or more QuerySets can be combined using the union operator with the following syntax:

You can also use the chain() method from the Itertools module, which allows you to combine two or more QuerySets from different models through concatenation.

Alternatively, you can use union() to combine two or more QuerySets from different models, passing all=TRUE if you want to allow duplicates.

Output on console:

And, you can use |= to add the queryset of the same model as shown below:

Output on console:

Be careful, if adding the queryset of a different model as shown below:

There is an error below:

But, if adding the empty queryset of a different model as shown below:

There is no error below:

Again be careful, if adding the object by get() as shown below:

Output on console:

And, you can use |= to add the queryset of the same model as shown below:

Output on console:

Be careful, if adding the queryset of a different model as shown below:

There is an error below:

But, if adding the empty queryset of a different model as shown below:

There is no error below:

You can also use the chain() method from the Itertools module, which allows you to combine two or more QuerySets from different models through concatenation. Alternatively, you can use union() to combine two or more QuerySets from different models, passing all=TRUE if you want to allow duplicates.

• Step2 Register your models. This is the code for models.py.
• Step3 Install your app in settings.py. Open your settings.py file and add your app name in installed app section.
• Step4 Create a superuser and migrate.
• Step5 Add entries in models created.
• Step6 Execute queries.