Help to implement join query in django orm

[Avi shah]

I have two tables 

Tbl 1 

& 

Tbl 2 

I need to connect the two tables using a join 

Thanks and regards, 

Avi shah 

[Ryan Nowakowski]

On Fri, Jul 22, 2022 at 12:16:14PM +0530, Avi shah wrote:
> I have two tables
> Tbl 1
> &
> Tbl 2
>
> I need to connect the two tables using a join

If these tables were created outside of Django, in other words, not
using manage.py migrate, you can use Django's legacy database support to
auto generate the models[1]. After that, each table will have a model
associated with it. You can then use Django's ForeignKey support to query
the tables.


[1] https://docs.djangoproject.com/en/4.0/howto/legacy-databases/

[Lalit Suthar]

this can be helpful
https://betterprogramming.pub/django-select-related-and-prefetch-related-f23043fd635d

--
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...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/20220723185935.GB15838%40fattuba.com.

[Abhishek Gupta]

Hey, you have to write custom raw query for join tables which are not connected with foreign key relationship in django.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAGp2JVHauj%2BS47HfmcYOrNQHJk3bTQbtdBm%3DdLRNx_8woM6XwQ%40mail.gmail.com.

[Jitendra kumar Patra]

Ping me 7008080545

--

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...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CALa7AFNmoep5MT3MwoYn1ZF0S%3DENPUdVAO-_3EmVyAzCub_Jkg%40mail.gmail.com.

[Mihir Patel]

is anyone having login issue? , i am unable to authenticate a user in my website

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAOAROf%3DgMPbSQ37f81A0rpRr7NgiUFF8ZyTsF8bZ-KG9Sgh%3DkA%40mail.gmail.com.

[Amitesh Sahay]

10. How to perform join operations in django ORM? — Django ORM Cookbook 2.0 documentation (agiliq.com)

Try this

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAC10kRFL%3D1a6T0-DG%3DZTsBugJa2_iFf-itHjSwAc9-2vHOnB7g%40mail.gmail.com.