Teradata supports multiple ways to delete data from a table using another table.

Teradata: Delete From Table

There are many scenarios where it is required to delete data either directly from a table or using another table.

Sample Table and Data

Basic Delete : Deleting from single table

DELETE FROM deletetable 
WHERE id=4;

Output:
*** Delete completed. One row deleted.


➠ Different approaches can be used to delete data from one table using other table.