Gr 12 – SQL Joins

I have shown you how to join tables using the WHERE clause. This is a great way to start understanding joins.

But there is a better way ie using the JOIN keyword (inner joins and outer joins)

Here is a very cool video explaining inner and outer joins in SQL.

More SQL Joins examples

NOTE: Yes, there are a few variations of SQL and they do not work in exactly the same way.