A select expression that defines which columns and rows of the
    specified tables SQL includes in the view. The select expression
    for a nonmultischema database can name only tables in the same
    schema as the view. A select expression for a multischema
    database can name a table in any schema in the database; the
    schema need not be in the same catalog as the view being created.
    See the Select_Expressions HELP topic for more information on
    select expressions.