Working with Statistica Query

• Query Overview
  
• Graphic Mode vs. Text Mode
  
• Graphic Mode Overview
  
• Text Mode Overview
  
• Join Overview
  
• Criteria Overview
  
• Select Database Query
  
• Database Connection
  
• Add Join
  
• Add Criteria
  
• Returning External Data to Spreadsheet
  
• Query File Menu
  These commands are available from the Query File menu in both the Graphic Mode and Text Mode. Note that options for saving and returning data to STATISTICA are only available when a database connection is displayed in the Tree pane. In addition to the options shown here, this menu contains a list of the most recently used query files. If you wish to display a previously used file, just select it here.
• Query Edit Menu
  These commands are available from the Query Edit menu. Note that options to Undo, Cut, Copy, Paste, and Select All text, are only available when you are in Text Mode. They will be grayed out when you are operating in Graphic Mode.
• Query View Menu
  
• Query Table Menu
  
• Query Join Menu
  
• Query Criteria Menu
  
• Query Help Menu
  
• Example - Querying a Database Using ODBC
  
• Example - Querying a Database Using OLE DB
  
• Can I save a query and use it later on another data set?
  

Copyright © 2021. Cloud Software Group, Inc. All Rights Reserved.