home *** CD-ROM | disk | FTP | other *** search
/ PC World 2002 May / PCWorld_2002-05_cd.bin / Software / Komercni / ability / ap / hlpshare.z / SQLGUIDE.CNT (.txt) < prev    next >
Encoding:
Microsoft Windows Help File Content  |  2000-04-03  |  1.4 KB  |  38 lines
  1. :Base sqlguide.HLP
  2. :Title SQL Guide
  3. 1 SQL guide
  4. 2 Introduction=SQL_Help
  5. 1 Selecting records
  6. 2 Selecting records - the basics=Selecting_records_the_basics
  7. 2 Calculated fields and renaming column titles=Calculated_fields_and_renaming_column_titles
  8. 2 Applying a sort order=Applying_a_sort_order
  9. 2 Selecting top records only=Selecting_top_records_only
  10. 2 Applying a condition=Applying_a_condition
  11. 2 Numeric comparisons=Numeric_comparisons
  12. 2 Date comparisons=Date_comparisons
  13. 2 Text comparisons=Text_comparisons
  14. 2 Wildcards=Wildcards
  15. 2 Selecting blank entries=Selecting_blank_entries
  16. 1 Grouping records
  17. 2 Groups and aggregate functions=Groups_and_aggregate_functions
  18. 2 Grouping on more than one level=Grouping_on_more_than_one_level
  19. 2 Finding duplicate records=Finding_duplicate_records
  20. 1 Crosstabs
  21. 2 Crosstabulations=Crosstabulations
  22. 2 Restricting pivot field values=Restricting_pivot_field_values
  23. 1 Relating tables
  24. 2 Relational links and joins=Relational_links_and_joins
  25. 2 Join types=Join_types
  26. 2 Unmatched queries=Unmatched_queries
  27. 1 Modifying records
  28. 2 Editing records=Editing_records
  29. 2 Updating records=Updating_records
  30. 2 Adding records=Adding_records
  31. 2 Adding multiple records=Adding_multiple_records
  32. 2 Creating tables from existing data=Creating_tables_from_existing_data
  33. 2 Deleting Records=Deleting_Records
  34. 1 Appendix - example data
  35. 2 Employee table=Employee_table
  36. 2 EmployeeSales table=EmployeeSales_table
  37. 2 Holiday table=Holiday_table
  38.