How to delete subset of records from a table?

UDA

How to delete subset of records from a table?

TableB is subset of TableA.

I want to delete TableB records from TableA.

How to do it?
1 REPLY

Re: How to delete subset of records from a table?

Let me answer to myself. I only managed to get the answer by Googling for the exact teradata sql error number.

Delete from some_table
Where (col1, col2, col3) in
(select *
from
(Select col1, col2, col3
From some_table
Sample 50) dt
);