Groups from SQL queries

If, when creating a group from the results of a SQL query, you find that the group doesn’t contain all of the records that you expect, then the explanation will probably be that your query isn’t returning the accountno field.

GoldMine is inconsistent in this regard. Sometimes a group will build happily without the accountno but often it doesn’t – you may get just a few records in the group or none at all.

To be on the safe side, always include the accountno in your list of SELECTed fields if you want to build a group from the results.