摘要 |
An apparatus identifies non-looked-up table fields to be grouped, and table fields having aggregate functions (307) to be performed in their row values in an SQL statement, and automatic inclusion with the SQL statement a subquery to generate a grouped derivative table comprising grouped non-looked-up table fields (311) and aggregated table fields, and one or more apropriate JOIN clauses(312) joining one or more target tables from which the table fields are to be looked up with the grouped derivative table.
|