7.2. Introducing Complex Queries

In the previous chapters, the queries could be classified as being relatively simple because references were always made against a single table. We now turn our attention to queries of a more complex nature that call on the full features of the SQL procedure. Four complex query constructs will be illustrated in this chapter.

Inner JoinsUp to 32 tables are referenced in a FROM and optional WHERE clause of a SELECT statement.
Outer JoinsA maximum of two tables are referenced in a FROM and ON clause of a SELECT statement.
SubqueriesA query is embedded (nested) in the WHERE clause of a main query.
Set OperationsA new results table is created from two separate queries.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
3.139.239.41