have posted comments requesting a basic explanation of the types of JOINs available in SQL. If you use the SQL command line to mine the ... table2.keyfield When you execute a statement like ...