About SQL Queries

Use SQL statements to query more than one database table at a time.

You can issue any valid SQL statement that conforms with Microsoft's implementation of the SQL 92 protocol from this tab. Because not all database management systems are fully compliant with the SQL 92 standard, review your system's documentation to see what SQL commands are valid for your particular database.

Unlike the other tabs in the Query Editor, the SQL Query tab can be used to construct a query that performs relational operations on multiple database tables using the SQL join operator. Because joins are a relatively advanced SQL operation, refer to your database system documentation or to the SQL 92 protocol for information about working with joins.