This option allows you to retrieve data from database tables.
To retrieve data from a database, choose the "Select " option from the "Select" list. Select the table you want to retrieve data from. Now you have three option to choose from :
To display all columns from the table, click the "All Columns" checkbox. After reviewing the SQL Query, click the "Run SQL Query" button to complete the operation. The result of the query will be displayed at the bottom of the page.
To display an individual column, choose the column you want to display from the "Individual Column Name" list. Ensure that option 1, "All Columns" is not highlighted. Click the "Build SQL Query" button. After reviewing the SQL Query click the "Run SQL Query" to complete the operation. The result of the query will be displayed at the bottom of the page.
To display data from the database using the aggregate functions, select your desired aggregate function from the "aggregate function" list. Choose the column from the "Column Name" list. Ensure that option 1, "All Columns" or option 2, Individual Column" are not highlighted. Click the "Build SQL Query" button. After reviewing the SQL Query click the "Run SQL Query" to complete the operation. The result of the query will be displayed at the bottom of the page.
You can use the "where clause" in order to pick out specific rows in a table by specifying a value that must be matched by the column in question. You should combine this by any one of the above options.
In the "optional where" panel, choose the column name from the "Column Name" list. Select "equal" or "like" from the drop-down menu and enter the matching value in the "Column Value" textbox.
Click the “Back” button to return to the query building page after you have generated a result set.