A SELECT statement can reference data in one or more sets of tables and views, including a mix of tables and views. The SELECT statement can define a join of tables or views.
You can join tables and views that have row-level security constraints, if the tables and views being joined have identical row-level security constraints. Otherwise, the system returns an error.
For more information about join operations, see Join Expressions.
For information about how the Optimizer processes joins, see Teradata Vantage™ - SQL Request and Transaction Processing, B035-1142.