Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 03 Dec 2007 @ 13:04:56 GMT

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

Subj:   Re: Issue in delete
From:   Victor Sokovin

  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?  

Nothing strange so far if the join is not one-to-one.



  <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: 15 Jun 2023