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.

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 ...

The acute observer will notice the borrower unique identifier (Borrower UID) appears in both the tables. By using this column of data, you can join the tables so that every time a row of data from the ...