SELECT company, AVG (net_amount), last_name FROM Sales GROUP BY company, last_name; The above example provides the average net_amount for each distinct last name in each company.

FROM table1, table2 WHERE table1.keyfield=table2.keyfield When you execute a statement like this, SQL creates a new table—the results recordset—based on the contents of table1 and table2.

Embarcadero added server-wide performance monitoring in InterBase 2017 based on repeated requests from independent software vendors (ISVs) to monitor multiple databases simultaneously in self ...