Appendix D -- Querying Multiple Tables

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


Microsoft Corporation - Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
Microsoft SQL Server 7 Data Warehousing Technical Support Training Kit
ISBN: 0735606706
EAN: 2147483647
Year: 1999
Pages: 114

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