Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 03 Dec 2007 @ 10:01:52 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Issue in delete
From:   Soumya Smita

I have a query of the below type:

     Delete fac
     FROM UD01_CDW_AGGR_TB.pl_colln_arrmt_fact fac, insert_into_fact del_fac
     Where fac.acct_id = del_fac.acct_id
       AND fac.acct_sfx_num = del_fac.acct_sfx_num
       AND fac.arrmt_made_dt = del_fac.arrmt_made_dt
       AND fac.arrmt_made_tm = del_fac.arrmt_made_tm
       AND fac.arrmt_due_dt  = del_fac.arrmt_due_dt

Although the higlighted join gives me 6500 rows but the delete statement that is operating on the same table deletes only 6300 rows. Any clues to this?

Thanks in advance!

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023