Learn to master the SQL command line with this crash course ... table1.keyfield=table2.keyfield When you execute a statement like this, SQL creates a new table—the results recordset—based ...