SQL LEFT JOIN clause is used to select all the matched records from the left side table, regardless if it has matched records in the right side table or not.
SQL Syntax
SQL Select Statements
SQL INNER JOIN
SQL INNER JOIN clause is used to select data from 2 (or more) tables, at least one match in both tables.
SQL HAVING
The SQL HAVING clause is similar to SQL WHERE clause. The difference is that the SQL HAVING clause is used in aggregate functions but the SQL WHERE clause cannot be used in aggregate functions.
SQL BETWEEN
The SQL BETWEEN operator is used to select data within a range between 2 values.
SQL GROUP BY
The SQL GROUP BY statement is used along with the aggregate functions to group the result dataset by one or more database table columns.