Chapter 7. Advanced Queries


In this chapter, we'll discuss more advanced queries. Principally, we will look at how we can run queries across multiple tables. This will involve learning about the concept of joins ”that is, how we join tables together.

We will cover the following:

  • Using joins to run queries over multiple tables, including:

    • Natural, inner, and cross joins

    • Straight joins

    • Left and right joins

  • Writing subqueries

  • Using SELECT statement options



MySQL Tutorial
MySQL Tutorial
ISBN: 0672325845
EAN: 2147483647
Year: 2003
Pages: 261

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net