About SQL query
The Edit SQL query screen allows you to modify the SQL queries that PHPRunner has built for you automatically.
This page includes:
•graphical panes that display your SQL statement (Query Designer tab);
•a text pane that shows the text of your SQL statement (SQL tab);
•the results of your query as a table with values (Results tab);
•additional WHERE clauses for the tabs on the List page (Additional WHERE tabs).
Design the SQL query in the Query Designer or SQL tab, then click Results to view the resulting table.
•a visual interface to design the queries;
•an automatic SQL Statement generation;
•creating joins with drag-n-drop;
•a grid pane to specify the criteria (ORDER BY, GROUP BY, WHERE, etc.);
•SQL parsing: enter the SQL statement to fill in the grid and diagram.