Using SQL to Select Records from Multiple Tables

Following on from my previous video introducing the SELECT query, this video shows how to use primary and foreign keys to connect up related tables when you need to retrieve records from both.
Prerequisite knowledge is:
Databases intro: • Relational Databases a...
SQL SELECT from one table: • Using SQL to Select Re...

[@justbee1917]

Hey MrBrown, thank you very much for posting this vid. Your explanation helped a lot.

[@user-fy6kj8gm4e]

I spent hours with lots of videos and posts and not a single saint could finally save me. Thank you very much Mr. Brown and just in time to sent my work for evaluation here from Brazil. Best regards, Diego

[@daniellebobb8170]

How do you bulk upsert a temp table into a target table when the temp table doesn't have a PK or common field with the target table?

[@Danieldrd]

Excellent video, thanks

[@aymansammo2460]

Much more helpful than my teacher at University, thank you so much

[@michaelmimichaelmi]

Literally why I'm here myself. Wish he taught my class.

[@DaBestOhYeah]

Really great Tutorial :)

[@hoylechannel339]

Thank you for your explanation. I hope you also use this in real life scenario. again thank you

[@shafiranurbadriyah1655]

thank you for your explanation

[@user-yn6tm6nb2r]

Thank you very much, it is very easy and clear

[@catharperfect7036]

Cheers for the vid my fellow chimpin code puppy

[@anshiyer4931]

Thank you so so so so much.

[@mineswah4363]

Thank you so much

[@eagle1573]

How can also I insert join statement in this query? Is it possible?

[@Kalocaball]

Thanks!!

[@CheeCarniel]

How do you select an aditional third table

[@mawhadmd7086]

same thing, just add the table like, FROM table 1, table 2, table 3

[@infokontent]

May God help you, it was a very useful video

[@user-ld1tz2de4o]

How can sql server using this on outer join situation

[@richard34urp]

Is this equivalent to JOINs ?

[@ComputerScienceTutor]

Yes that can be used as an alternative

[@Myself_9037]

I have a doubt. I have table with two fields, one field is array in table 1
uID | Contact
2 | 1221,1223
3 | 1123
Now value of 1221 and 1223 are in table Two. I want a query to join table 1 and table 2 using array of field2

[@alexyakoveno4682]