Read this SQL tutorial to learn when to use SELECT, JOIN, subselects and UNION to access multiple tables with a single statement. It’s sometimes difficult to know which SQL syntax to use when ...

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.

Ask it to perform simple queries like “Select all records from a table” or more complex ones like “Retrieve data from multiple tables using joins.“ Here’s the SQL query to select all ...