Archives of the TeradataForum
Message Posted: Fri, 25 Jan 2008 @ 09:02:43 GMT
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 ) ;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|