How to Create Joins in SQLAlchemy

In this video I will show you how to join your models/tables in Flask-SQLAlchemy.

[madetochilltrivia]

After hours and hours, this video explained CLEARLY what I needed to do. Anthony, you are an amazing teacher. Thank you!!

[goonbreathfpv]

Amazing. Everywhere tells you to put a relationship on the parent table and FK on the child, but you did none of that. This works exactly how I thought it should with regards to the linked tables.

[emerssonflores]

Thanks for the video, I was looking for this solution all day on forums and I finally made my code work with this, exactly what I was looking for, I appreciate it <3

[maxwellpatten]

this is EXACTLY what I was looking for .... thank you so so much! you are awesome!!!

[thecaveofthedead]

Thanks for this. I was getting completely confused on stackoverflow. This explanation helped me deal with a many-to-many relationship in which the association table is a class to allow for extra columns. A three table join and I can get what I want out of the query.

[tradewinds]

Thanks for this and especially for sharing the code.

[ondrejlubovsky]

Thanks. It was exactly I was looking for.

[iamhazelnuts]

You are an absolute legend, thank you!!

[sindiso_ndlovu]

My brother you're heaven sent we really appreciate man 🙏

[trungkienhuynh]

Thank you. This seriously saved my day.

[ssheike]

Thankssss. really helpped me in a 5 tables search

[drmlbrt]

how come, that the query with select_from gives in the for loop a double results. Each 'row, comes twice?

[ColinBroderickMaths]

Why is it I have to write a query that asks for Employee AND Department and then I have to say .join(Department) anyway?

[venkatgangarapu]

Hi, I am trying to do similar join but i get error when try to print details of child table, anythoughts ? it is only giving me id column

[chriskeo]

Line 25

Could you use Employee in the . join? Why did you use department?

[WaldoTheWombat]

why is it
db.session.query(Employee,
and not
db.session.query(Employee, ?

[pipi_delina]

Hi ... I have a question regarding the models

[smamoden]

Hy, Can u plz do a Flasq GraphQL video

[aswinishrestha]

I have a confusion about when to use SQLAlchemy. I have seen you creating a sql file and transfering the code to sqlite database through command to create tables. But for making blogs you are using SQLAlchemy. I am so confused when to use what as I am new to flask.