Chapter 12. Joins


This chapter covers the following exam topics:

  • Writing inner joins using the comma (',') operator and INNER JOIN

  • Writing outer joins using LEFT JOIN and RIGHT JOIN

  • Resolving name clashes using qualifiers and aliases

  • Writing self-joins

  • Multiple-table UPDATE and DELETE statements



MySQL 5 Certification Study Guide
MySQL 5.0 Certification Study Guide
ISBN: 0672328127
EAN: 2147483647
Year: 2006
Pages: 312

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