GP Query Builder
Visual SQL generator — Dynamics GP
← Undo
Clear
← Back to GP Tables
02
Add joins
03
Select columns
04
Row limit (TOP N)
Enable TOP N
rows
05
Aggregates / GROUP BY
Enable GROUP BY
+ add aggregate
06
Filters (WHERE)
+ add filter
07
Order by
Sort field
ASC
DESC
⬡
Select a table from the sidebar to begin building your query
Generated SQL
SQL Server 2017
copy
-- Select a table to begin