SQL Query Builder

SQL Query Builder - SQL tab

Navigator > Setup > SQL Query Builder > SQL tab

Shows the SQL query created by using Query Builder tools on the Query Layout tab. You can write a query without using the Query Builder. You can edit the query to refine it by typing directly or using the options at the top of the screen.

	SQL `(Alt+S)`	Provides a drop-down of commonly used SQL Clauses.
	Operators `(Alt+O)`	Provides a drop-down of SQL operators.
	Functions `(Alt+F)`	Provides a drop-down of SQL functions.
	Fields `(Alt+D)`	Provides a drop-down of every module in Accredo. Select a module, a list of tables in that module is shown. Select a table, and a drop-down shows the fields available in that table.
	Help `(Alt+H)`	View help on Syntax (SQL Clauses), Functions, and Operators.