GP Query Builder | Dynamics GP Table Reference

GP Query Builder

Visual SQL generator — Dynamics GP

← Undo Clear ← Back to GP Tables

Module

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