A Gold Mine customer asked: How do I use a SQL Query to create a group?
First, run your SQL Query so the results are on the screen: Tools > Filters and Groups > SQL Query tab.
Switch to the Groups tab > Click on New Group.
Enter a Group Name.
The Code field can be used for anything you'd like. Since Groups are static, i.e. they do not automatically update, it’s a good idea to put in the date they're created so you know at a glance when the group was created.
Be sure the Build Group box is checked, click OK.
In the Group Building Wizard, click the SQL Query Records radio button. (If this is grayed out it means there is nothing appearing in the SQL Query tab.)
Choose whether and how to sort your group, if you want any fields brought over into the Reference field, and if you need to limit the size of the group.
Click Next > Finish.