Archives of the TeradataForum

Message Posted: Fri, 25 Jan 2008 @ 09:02:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi

I want to delete the records through Delete Mload.

If some one is having any sample script for delete mload please send it to me.

This is my script which needs to be converted into Delete Mload.

     DELETE  A FROM Table  A WHERE
     EXISTS ( SELECT 1 FROM
     Table B WHERE
     A.col1 = B.col1 AND A.col2 = B.col2
     AND A.col3 = B.col3
     ) ;

Regards

Rahul Dharmawat
Consultant | Technology

	<Prev	Next>		<<First	<Prev	Next>	Last>>