Join two querysets django

# you need to have a foreign key relationship defined in the models.py first 
class OrderModelName(models.Model):
  	order_id = models.IntegerField(primary_key=True,  db_column='order_id')
	item_id = models.ForeignKey(ItemModelName, db_column='item_id', on_delete=models.RESTRICT, null=True, blank=True)
# Then in views.py you can pull in foreign fields in your queryset using 
# foreignkeyfield__fieldonforeigntable Example:
def your_view(request):
	data = OrderModelName.objects.all().values(order_id, item_id__item_name)

Merge two query sets django

querySet1.union(querySet2, querySet3, etc) #Minimum 1 argument # Subscribe to GuruTheCoder.

Similar codes

2 votes305 views2 answers
Check if a number is integer or decimal in Python
Python
11 votes348 views2 answers
Python cls statement using os module
Python
0 vote302 views1 answer
How to get the positions where values of two columns match?
Python
41 votes279 views6 answers
How to flatten list of lists in python
Python
13 votes340 views5 answers
Converting numpy array to dataframe
Python
0 vote320 views1 answer
Python pandas rellenar con ceros a la izquierda
Python
12 votes337 views4 answers
Merge three dataframes pandas based on column
Python
0 vote313 views1 answer
Python datetime now only date
Python
0 vote305 views1 answer
Global variable not accessible withing thread
Python
21 votes342 views3 answers
How to create an empty list of certain length in python
Python