Nonsequenced transaction-time queries on transaction-time tables produce nontemporal tables as a result. Use the NONSEQUENCED TRANSACTIONTIME qualifier to query and compare across all transaction-time states simultaneously.
The nonsequenced query treats a transaction-time table as a table with a regular Period column with no special temporal semantics. References to the transaction-time column can appear anywhere in the query.
If the projection list specifies *, the transaction-time column is also projected.
If the query involves a bitemporal or valid-time table, refer to the following topics for additional information that applies to the valid-time dimension: