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