The first step in creating an SQL statement is selecting the tables in the database you want to query, add to, or update. Knowing how data in your database is organized will help you make informed decisions.
A simple query accesses the data in one table. The SQL Wizard can build more complex queries based on data in two or more tables using an inner join. To join tables using an outer join, you need to enter your query manually. For more information about joining tables, see Entering or Pasting an SQL Select Statement.
