Re: merge fields from different table

hello i am not from the py community so please remove me from this section.

                                                   thanks

On Sat, Nov 5, 2022 at 12:06 AM Ammar Mohammed <amarben1000@gmail.com> wrote:

Get your Locations object :

obj = Locations.objects.get(pk=1)

Then get the region:

obj.region.region_name 

On Fri, 4 Nov 2022, 7:29 PM Kala Rani, <ranimca28@gmail.com> wrote:

models.py

class Regions(models.Model): 

 region_name = models.CharField(max_length=255) 

  class Locations(models.Model): region = models.ForeignKey(Regions, on_delete=models.CASCADE,blank=True,null=True) name = models.CharField(max_length=255) 

How to do this query in django?

select locations.name,regions.region_name from locations inner join regions on locations.region_id = regions.id order by locations.name; 

I want to show in select tag like country-city

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/29b954e2-646d-4b58-ba0d-381660ba2f33n%40googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAHs1H7t8M2L_P-xwUBD3B_3VWT_JwOgYRsFiXnTLcBq%2BsdfDhw%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CABqedVMga-e5uE-aNaZfEwxhX3j_LBP%2B3mYiOxCJKPwB2cGsaw%40mail.gmail.com.