Create an SQL view to produce a set of fields that you can use as a table in a single table or table pair. In an SQL view definition, you specify an SQL statement that can combine multiple sources, calculate field values, and filter columns and rows.
You can create an SQL view based on one or more relational tables that exist in the same database.
When you specify the SQL statement for an SQL view, you can add database functions, any join type, subqueries, and stored procedures in the SQL statement.
When you run a single-table test or table-pair test based on an SQL view, the database processes the SQL statement defined for the SQL view.