17.05 - Example: Using the table_name.* Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Manipulation Language

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following statement returns only those rows from the employee table whose values in the empno column match the values in the mgr_no column of the department table.

This example uses the table_name.* form of the select list.

     SELECT employee.*
     FROM employee, department
     WHERE employee.empno=department.mgr_no;