About This Appendix
In this appendix, you will learn how to combine the data from multiple tables into useful result sets. Individual tables in a normalized database provide limited data. These tables need to be combined in order to provide useful data to applications and users. You will learn how to use SQL joins to provide this data.
Before You Begin
To complete the lessons in this appendix, you must
- Have installed SQL Server 7.0
- Be able to log on SQL Server with Administrator rights
- Know the basics of SQL (Appendix C covers basic SQL queries, including exercises)
- Run the C:\SQLDW\Exercise\bldlib\bldlib.CMD batch file with an appendix argument of D
- Open the C:\SQLDW\Exercise\AppD\joindb.SQL script and execute it to create the joindb database, which is used for some of the examples in this appendix