:Base sqlguide.HLP
1 SQL Guide
2 SQL guide
3 Introduction=SQL_Help
2 Selecting records
3 Selecting records - the basics=Selecting_records_the_basics
3 Calculated fields and renaming column titles=Calculated_fields_and_renaming_column_titles
3 Applying a sort order=Applying_a_sort_order
3 Selecting top records only=Selecting_top_records_only
3 Applying a condition=Applying_a_condition
3 Numeric comparisons=Numeric_comparisons
3 Date comparisons=Date_comparisons
3 Text comparisons=Text_comparisons
3 Wildcards=Wildcards
3 Selecting blank entries=Selecting_blank_entries
2 Grouping records
3 Groups and aggregate functions=Groups_and_aggregate_functions
3 Grouping on more than one level=Grouping_on_more_than_one_level
3 Finding duplicate records=Finding_duplicate_records
2 Crosstabs
3 Crosstabulations=Crosstabulations
3 Restricting pivot field values=Restricting_pivot_field_values
2 Relating tables
3 Relational links and joins=Relational_links_and_joins
3 Join types=Join_types
3 Unmatched queries=Unmatched_queries
2 Modifying records
3 Editing records=Editing_records
3 Updating records=Updating_records
3 Adding records=Adding_records
3 Adding multiple records=Adding_multiple_records
3 Creating tables from existing data=Creating_tables_from_existing_data
3 Deleting Records=Deleting_Records
2 Appendix - example data
3 Employee table=Employee_table
3 EmployeeSales table=EmployeeSales_table
3 Holiday table=Holiday_table