SELECT Statements

Use the SELECT statements you create in the SQL Statement Builder to extract data for display in your Proficy Portal run-time environment. As you select table columns and criteria in the graphic design and query designation areas, the code for the SQL statement appears in the results and viewing area. You can use the Criteria Logic tab to view the interactions of the parts of the statements that you are building, and you can set several variables that affect the design of your statement, as well as the return of data. The color coding in the graphic design area and the query specification area gives you instant feedback about the details of the statement.

When you add a table to a SELECT statement, all columns in that table are automatically returned. If you want to return a different set of columns, you can select the columns to include from the Query Specification tab or by specifically selecting the columns in the Table Diagram.

See Also