Introduction To Structured Query Language (SQL) – Part 2

Querying the database – the SELECT statement

Topics by page

• Queries and views: Overview


• SELECT – two tables: Examples


• Types of JOIN


• SELECT from two tables: Exercises


• SELECT from two tables: Syntax


• Multiple table SELECT


• OUTER JOIN example


• Set operations: UNION


• UNION query: Exercises


• Pass-through queries (concept)

SQL statements

All pages