Real Life Dynamics GP user has a nice look at the basics of how to use SQL Views.
How to Use SQL Views
SQL & DataTips & Hidden Features
Archived post from 2010. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.