▶ C'mon over to https://realpars.com
where you can learn PLC programming faster and easier than you ever thought possible!
▶ Check out the full blog post over at https://realpars.com/sql-join/
If you are just now joining along with this series of videos, please note that you are going to learn about SQL programming basics.
If you would like to follow along with us, please review the RealPars video, “How to install MySQL and import a sample database”, on how to download and setup MySQL database on your computer.
In the previous video, "What is the SQL Create Table Clause Statement Language Element?" (https://realpars.com/sql-create-table/), we used the Create Table statements to create new tables, t1 and t2, in the RealPars sample database.
In this video, you will learn about some of the advanced SQL statements and clause commands for CROSS JOIN, INNER JOIN, and Union language elements.
To form an INNER JOIN, you will need a condition that is known as a join-predicate. An INNER JOIN requires rows in the two joined tables to have matching column values.
The INNER JOIN creates the result set by combining column values of two joined tables based on the join-predicate.
The INNER JOIN compares each row in the first table with each row in the second table to find pairs of rows that satisfy the join-predicate.
Whenever the join-predicate is satisfied by matching non-NULL values, column values for each matched pair of rows of these two tables are included in the result set.
The UNION operator allows you to combine two or more result sets of queries into a single result-set. This statement will eliminate duplicate rows.
The Drop Table statements will delete tables.
To learn more about MySQL and additional SQL statements, visit the MySQL website: https://dev.mysql.com/doc/refman/8.0/en/join.html
Review the MySQL minimum hardware requirement web page here: https://forums.mysql.com/read.php?11
Download the MySQL Installer: https://dev.mysql.com/downloads/installer/
Download the sample database SQL file from here: https://realpars.com/wp-content/uploads/2019/12/realparssampledatabasev2.zip
Download the sample database diagram file from here: https://realpars.com/wp-content/uploads/2020/01/RealParsSampleDatabaseV2-Diagram.zip
Missed our most recent videos? Watch them here:
How to Install MySQL and Import a Sample Database (Part 1 of 8) https://realpars.com/mysql
What are SQL Programming Basics? (Part 2 of 8) https://realpars.com/sql
What are SQL Where and Like Statements Basics? (Part 3 of 8) https://realpars.com/sql-where
What are the SQL Order By Clause and Expression Statement Language Elements? (Part 4 of 8) https://realpars.com/sql-order-by/
What are the SQL Inner Join, And, Or, Having and Between Clause? (Part 5 of 8) https://realpars.com/inner-join/
What are the SQL Subquery and Exists Clause Statement Language Elements? (Part 6 of 8) https://realpars.com/sql-subquery/
What is the SQL Create Table Clause Statement Language Element? (Part 7 of 8) https://realpars.com/sql-create-table/
To stay up to date with our last videos and more lessons, make sure to subscribe to this YouTube channel:
TWEET THIS VIDEO https://ctt.ac/9l2f5
Like us on Facebook: https://www.facebook.com/therealpars/
Follow us on Twitter: https://twitter.com/realpars
Follow us on LinkedIn https://www.linkedin.com/company/realpars
Follow us on Instagram https://www.instagram.com/realparsdotcom/
#RealPars #SQL #MySQL