GoldMIne Tip: How to create a Group from an SQL Query #goldmine

An 'SQL Query' in GoldMine is a more advanced tool to create a list of Contacts based on ANY information in GoldMine, where maybe a Filter or Group would be impossible.  Here's how to create a permanent Group on that Query:

- Select Tools | SQL Query
- The ‘SQL Query Windows’ appears
- Enter and execute your SQL query

- Select the ‘Groups’ tab
- Click on the ‘New Group’ button
- Enter the name of the Group | Click on the ‘OK’ button
- The ‘Welcome to Group Building Wizard’ dialog box appears
- Select the ‘SQL Query Records’ option
- Click on the ‘Next’ button
- Click on the ‘Next’ button
- Click on the ‘Finish’ button