Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Regarding Delete Mload
 
From:   Dharmawat, Rahul

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016