But how many rows (records) will the new table contain? The answer depends on the WHERE clause. In this sample statement, the condition (table1.keyfield=table2.keyfield) tells SQL to find records ...

For tables that see frequent additions ... the indexes and restores speedy access. Microsoft's SQL Server has a handy command that rebuilds all indexes in a table. Oracle users typically rebuild ...

Build a SELECT statement similar ... of two queries into a new table. When working with databases other than Microsoft's SQL Server, check the manual to see if it supports SELECT INTO.

SEE: Take advantage of these quick SQL lessions with this certification ... You can call more than one table in the statement’s FROM clause to combine results from multiple tables.