3/4 - More JOIN

EQUIJOIN
-equal value between primary key and foreign key in a pair of tables

SELF JOIN
-involves just one table
-will only happen for tables that have a unary relationship existing between them

OUTER JOIN
-use to see rows that do not usually meet the join condition
-LEFT JOIN
    > takes table on left side of JOIN keyword
-RIGHT JOIN
    > takes table on right side of JOIN keyword

NON-EQUIJOIN
-special case where you do not use primary key and foreign key to join rows

---------------------------------------------------------------------------

MySQL functions
-SELECT COUNT(*) FROM product_t