www.it-ebooks.info
Mastering SQL Queries for SAP Business One
Utilize the power of SQL queries to bring Business Intelligence to your small to medium-sized business
Do
Gordon Du
professional expertise distilled
P U B L I S H I N G BIRMINGHAM - MUMBAI
www.it-ebooks.info
Mastering SQL Queries for SAP Business One Copyright © 2011 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, without the prior written permission of the publisher, except in the case of brief quotations embedded in critical articles or reviews. Every effort has been made in the preparation of this book to ensure the accuracy of the information presented. However, the information contained in this book is sold without warranty, either express or implied. Neither the author, nor Packt Publishing, and its dealers and distributors will be held liable for any damages caused or alleged to be caused directly or indirectly by this book. Packt Publishing has endeavored to provide trademark information about all of the companies and products mentioned in this book by the appropriate use of capitals. However, Packt Publishing cannot guarantee the accuracy of this information.
First published: May 2011
Production Reference: 2190511
Published by Packt Publishing Ltd. 32 Lincoln Road Olton Birmingham, B27 6PA, UK. ISBN 978-1-849682-36-7 www.packtpub.com
Cover Image by David Guettirrez (
[email protected])
www.it-ebooks.info
Credits Author
Project Coordinator
Gordon Du
Vishal Bodwani
Reviewers
Proofreader
Zal Parchem
Aaron Nash
Muddassar Imran Indexer
Wolfgang Niefert
Monica Ajmera Acquisition Editor Graphics
Stephanie Moss
Geetanjali Sawant Development Editor Production Coordinator
Susmita Panda
Arvindkumar Gupta Technical Editor Cover Work
Pallavi Kachare
Arvindkumar Gupta Copy Editor Laxmi Subramanian
www.it-ebooks.info
About the Author Gordon Du studied System Engineering and Computer Science at the Nankai University in Tianjin, China. He has over 28 years of experience in diversified information technology fields. His experience with SQL goes back to 1987.
Gordon was the first person in China to successfully implement an international software package for a Chinese investment-only company in 1995. Gordon has been the top contributor on the SAP Business One forum since August 2008. He has been awarded 45,000 points as of January 16, 2011. This is the highest lifetime points recorded by SAP Community Network for a non-SAP employee since 2004. Over 25 percent of Gordon's points are related to solving SQL query questions and problems posted by other forum members. Here are some links demonstrating this. His SCN profile link for reference: http://forums.sdn.sap.com/profile.jspa?userID=4130357
His first blog on SCN: http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17099
The congratulations and thanks thread to his 35,000 points from forum users: http://forums.sdn.sap.com/thread.jspa?threadID=1718298&tstart=0
Gordon has worked and trained extensiv