16.20 - CROSS JOIN - Teradata Database - Teradata Vantage NewSQL Engine

A CROSS JOIN is an unconstrained, or Cartesian join. The Cartesian product of two tables/views returns a concatenated product of all rows from all tables or views specified in the FROM clause.

single_table

Name of a user base table or view participating in the join.

You cannot create or replace a view on a queue table (see CREATE TABLE (Queue Table Form)).