PostgreSQL: Inner Joins | Course | 2019

[@london2resistance]

You helped me out a lot for a course I'm doing, very professionally developed content that's very easy to understand. Big thanks bro!

[@sairao4492]

Thanks for the clear explanation and example! That expanded display mode is very convenient. I first saw your channel when you hosted on The Coding Train. Keep up the great videos!

[@wynez1]

Just note for myself: 5:29 : '/x - Expanded display is off

[@しげお-i1l]

Great video but I think using A + B to describe a Inner join is not appropriate. That could lead someone to think that the result would be like a Outer Join, where all rows from A and B would be included regardless.

[@AliceNicolas-ts7ri]

this is such a big help. thank you for the tips

[@ireallylikecoffee14]

Good video!

[@dhikeshmm620]

i have one doubt,, if there is no common items in both table it supposed to show NULL right but as per your video it shows both table together.. is that if there is no common items it will take both table together.. can anybody clarify the doubt.

[@florincaroli]

Thank you!

[@djslimcodes2337]

@Amigoscode at 5:50 I have a question, what are the rules those rows are sorted, because Fernanda should be at first position as it has id = 1 and it's already first on person table?

[@Friend_2162]

I know it is 3 years but the answer is: The people are sorted by last update (last updated rows are at bottom). If you want to sort by id, you must use ORDER BY id

[@should_be_username]

Hi bro thanks for knowledge!

[@TheJollyRhino]

How would we use the ORDER BY within the query?

[@saoussenslii]

excellent

[@kxrxkt6741]

thank you

[@عابثالأخير-ز9ي]

I have a question, can i joining more than two tables such as three or four in the same time?, if i can pls show query

[@amigoscode]

Yes. you can. its same process

[@عابثالأخير-ز9ي]

@@amigoscode thank you

[@bartstyn]

@@amigoscode I can not get the query to work... I'm trying to join 5 tables, because I need information of 3 of them and they are linked together in this way. I've been trying it like this: SELECT film.title, location.country, programme.programme_date FROM film JOIN programmeitem ON film.film_id = programmeitem.film_id FROM programmeitem JOIN programme ON programmeitem.programme_id = programme.programme_id FROM programme JOIN venue ON programme.venue_id = venue.venue_id FROM venue JOIN location ON venue.location_id = location.location_id WHERE location.country = NLD AND programme.programme_date >= '1900-01-01' AND programme.programme_date < '1911-01-01'; Thanks a lot!

[@self-toughstudy6635]

@@bartstyn, I guess having multiple FROM clauses is incorrect here. As I understand the general logic, we select from a table and join with another table on a specific column. If we already specified which table to join with, the FROM after JOIN doesn't make sense. Something like this might work here: ``` SELECT film.title, location.country, programme.programme_date FROM film JOIN programmeitem ON film.film_id = programmeitem.film_id JOIN programme ON programmeitem.programme_id = programme.programme_id JOIN venue ON programme.venue_id = venue.venue_id JOIN location ON venue.location_id = location.location_id WHERE location.country = 'NLD' AND programme.programme_date >= '1900-01-01' AND programme.programme_date < '1911-01-01'; ```

[@codingislive4617]

thank you bro