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

SQL lets you use one command to quickly create a new table containing a subset of records from a larger table while working in Access. Sound complicated? It's not, as Mary Ann Richardson shows us.

9 best practices for faster SQL queries Retrieve only the columns you need Use CASE instead of UPDATE for conditional column updates Keep large-table queries to a minimum Pre-stage your data ...

1. Index by workload, not by table Many people make the mistake of just guessing at some indexes to create when they are creating database tables. Without an idea of how the tables are going to be ...

SQL/XML is a small extension to SQL that allows a SQL query to create any desired XML structure. For a SQL programmer it requires little new learning, and it allows existing databases to be used ...