Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

In most implementations of SQL, you pull information from two tables by using a SELECT command in this form: SELECT table1.column1, table1.column2, table2.column1, table2.column2 ...

A join combines two or more tables side by side. If you do not specify how to join the tables, you get a Cartesian product.This means that SQL combines each row from the first table with every row ...

Outer joins are inner joins that have been augmented with rows that did not match with any row from the other table in the join. The three types of outer joins are left, right, and full. A left outer ...

Analyze database contents using basic, intermediate and advanced SQL statement syntax and usage. Demonstrate capability to query data from multiple tables using SQL JOINS. Create and modify database ...