Batini

SQL
FOR

®

DUMmIES
5TH by Allen G. Taylor

‰

EDITION

SQL
FOR

®

DUMmIES
5TH by Allen G. Taylor

‰

EDITION

SQL For Dummies ® 5th Edition ,
Published by Wiley Publishing, Inc. 111 River Street Hoboken, NJ 07030 www.wiley.com Copyright © 2003 by Wiley Publishing, Inc., Indianapolis, Indiana Published by Wiley Publishing, Inc., Indianapolis, Indiana Publishedsimultaneously in Canada No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment ofthe appropriate licensing fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 646-8700. Requests to the Publisher for permission should be addressed to the Legal Department, Wiley Publishing, Inc., 10475 Crosspoint Blvd., Indianapolis, IN 46256, (317) 572-3447, fax (317) 572-4447, e-mail: permcoord inator@wiley.com. Trademarks: Wiley, the WileyPublishing logo, For Dummies, the Dummies Man logo, A Reference for the Rest of Us!, The Dummies Way, Dummies Daily, The Fun and Easy Way, Dummies.com and related trade dress are trademarks or registered trademarks of Wiley Publishing, Inc., in the United States and other countries, and may not be used without written permission All other trademarks are the property of their respective owners.Wiley Publishing, Inc., is not associated with any product or vendor mentioned in this book. LIMIT OF LIABILITY/DISCLAIMER OF WARRANTY: WHILE THE PUBLISHER AND AUTHOR HAVE USED THEIR BEST EFFORTS IN PREPARING THIS BOOK, THEY MAKE NO REPRESENTATIONS OR WARRANTIES WITH RESPECT TO THE ACCURACY OR COMPLETENESS OF THE CONTENTS OF THIS BOOK AND SPECIFICALLY DISCLAIM ANY IMPLIED WARRANTIES OFMERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. NO WARRANTY MAY BE CREATED OR EXTENDED BY SALES REPRESENTATIVES OR WRITTEN SALES MATERIALS. THE ADVICE AND STRATEGIES CONTAINED HEREIN MAY NOT BE SUITABLE FOR YOUR SITUATION. YOU SHOULD CONSULT WITH A PROFESSIONAL WHERE APPROPRIATE. NEITHER THE PUBLISHER NOR AUTHOR SHALL BE LIABLE FOR ANY LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGES, INCLUDING BUT NOTLIMITED TO SPECIAL, INCIDENTAL, CONSEQUENTIAL, OR OTHER DAMAGES. For general information on our other products and services or to obtain technical support, please contact our Customer Care Department within the U.S. at 800-762-2974, outside the U.S. at 317-572-3993, or fax 317-572-4002. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not beavailable in electronic books. Library of Congress Control Number: 2003105668 ISBN: 07645-4075-0 Manufactured in the United States of America 10 9 8 7 6 5 4 3 2 1

is a trademark of Wiley Publishing, Inc.

About the Author
Allen G. Taylor is a 30-year veteran of the computer industry and the author of 22 books, including Crystal Reports 9 For Dummies, Database Development For Dummies, AccessPower Programming with VBA, and SQL Weekend Crash Course. He lectures internationally on databases, networks, innovation, and entrepreneurship. He also teaches database development through a leading online education provider and teaches digital electronics at Portland State University. He teaches computer hardware via distance learning at the International Institute for Information, Science &Technology in Shanghai, China. For the latest news on Allen’s activities, check out allengtaylor.com. You can contact Allen at allen.taylor@ieee.org.

Dedication
This book is dedicated to all the seekers who are trying to find their way in the world. May you find what you seek.

Acknowledgments
First and foremost, I would like to acknowledge the help of Jim Melton, editor of the ISO/ANSI...