Multi-part looked-up table fields and its use in data processing operations involving multiple tables of a relational database

摘要: In accordance with a first aspect, software component is equipped to identify non-looked-up table fields and looked-up be grouped, having aggregate functions performed in their row values data processing statement, automatic inclusion SQL statement subquery generate grouped derivative comprising aggregated fields, one or more appropriate JOIN clauses joining target tables from which the are looked up table. embodiment, expressed multi-part form. second automatically expand available for operation include of look-up field, selection aggregation function.