Copyright

Many of the designations used by manufacturers and sellers to distinguish their products are claimed as trademarks. Where those designations appear in this book, and the publisher was aware of a trademark claim, the designations have been printed with initial capital letters or in all capitals.

The authors and publisher have taken care in the preparation of this book, but make no expressed or implied warranty of any kind and assume no responsibility for errors or omissions. No liability is assumed for incidental or consequential damages in connection with or arising out of the use of the information or programs contained herein.

The publisher offers excellent discounts on this book when ordered in quantity for bulk purchases or special sales, which may include electronic versions and/or custom covers and content particular to your business, training goals, marketing focus, and branding interests. For more information, please contact: U.S. Corporate and Government Sales, (800) 382-3419 corpsales@pearsontechgroup.com

For sales outside the United States please contact: International Sales, international@pearsoned.com

Visit us on the Web: informit.com/aw

Library of Congress Cataloging-in-Publication Data

Viescas, John L., 1947-
 SQL queries for mere mortals : a hands-on guide to data manipulation in
SQL / John L. Viescas and Michael J. Hernandez. — 2nd ed.
     p. cm.
 On t.p. of previous ed. Michael J. Hernandez’s name appeared first.
 Includes index.
 ISBN 0-321-44443-4 (pbk. : alk. paper)
 1. SQL (Computer program language) 2.  Database searching.  I. Hernandez,
Michael J. (Michael James), 1955-  II. Viescas, John L., 1947- SQL queries for
mere mortals. III. Title.

  QA76.73.S67H48 2007
  005.75’85—dc22                                          2007026881

Copyright © 2008 by Michael J. Hernandez and John L. Viescas

All rights reserved. Printed in the United States of America. This publication is protected by copyright, and permission must be obtained from the publisher prior to any prohibited reproduction, storage in a retrieval system, or transmission in any form or by any means, electronic, mechanical, photocopying, recording, or likewise. To obtain permission to use material from this work, please submit a written request to Pearson Education, Inc., Permissions Department, One Lake Street, Upper Saddle River, New Jersey 07458, or you may fax your request to (201) 236-3290.

ISBN-13: 978-0-321-44443-1

Text printed in the United States on recycled paper at Courier in Westford, Massachusetts.

Seventh printing, September 2011

Editor-in-Chief: Karen Gettman
Acquisitions Editor: Chuck Toporek
Managing Editor: John Fuller
Project Editor: Elizabeth Ryan
Copy Editor: Chrysta Meadowbrooke
Indexer: Coughlin Indexing
Proofreader: Mike Shelton
Cover Designer: Alan Clements
Composition: Pine Tree Composition
Technical Reviewers: Keith Hare, Stephen Forte